Solved

Excel - IF statement when true/false cell is is empty

Posted on 2010-11-10
6
702 Views
Last Modified: 2012-06-27
Hi,
Is it possible to use a IF statement when the true / false cell is empty, to leave it blank?

When I use the formula below It will only give me the false value when the cell is empty, is there a way to leave it blank when the cell has no value, in VBA or through formula?

The whole column O will have this formula..

This is the forumula I use:
=IF(O39;"Fakturert";"Opptjent") 

Open in new window

0
Comment
Question by:agepab
6 Comments
 
LVL 50

Expert Comment

by:teylyn
Comment Utility
Hello,

try

=IF(isblank(O39);""if(O39;"Fakturert";"Opptjent"))

If a cell is blank, it will result in 0 for the IF(O39... part, so you want to check if it is empty to get a "" result.

cheers, teylyn
0
 
LVL 50

Accepted Solution

by:
teylyn earned 42 total points
Comment Utility
Sorry, missed a ;

corrected:

=IF(isblank(O39);"";if(O39;"Fakturert";"Opptjent"))

0
 
LVL 58

Assisted Solution

by:cyberkiwi
cyberkiwi earned 42 total points
Comment Utility
Do semicolons work?
Anyway, I use

=if(039="","",if(o39,"Fakturert","Opptjent"))
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 50

Assisted Solution

by:barry houdini
barry houdini earned 41 total points
Comment Utility
try

=IF(O39="";"";IF(O39;"fakturert";"Opptjent"))

Regards, barry
0
 

Author Closing Comment

by:agepab
Comment Utility
Perfect and ultrafast;)

Thanks all
0
 
LVL 50

Expert Comment

by:teylyn
Comment Utility
@cyberkiwi,

think globally!

>> Do semicolons work?

Yes. In fact, they're the only thing that works, depending on your regional settings, especially with regards to list separators. Most European language versions of Excel use the ; instead of the , to separate elements of a function.

cheers, teylyn

0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now