Solved

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

Posted on 2010-11-10
6
703 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:Ingeborg Hawighorst
ID: 34100427
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:
Ingeborg Hawighorst earned 42 total points
ID: 34100430
Sorry, missed a ;

corrected:

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

0
 
LVL 58

Assisted Solution

by:cyberkiwi
cyberkiwi earned 42 total points
ID: 34100431
Do semicolons work?
Anyway, I use

=if(039="","",if(o39,"Fakturert","Opptjent"))
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 50

Assisted Solution

by:barry houdini
barry houdini earned 41 total points
ID: 34100438
try

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

Regards, barry
0
 

Author Closing Comment

by:agepab
ID: 34100463
Perfect and ultrafast;)

Thanks all
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 34100508
@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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

912 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

26 Experts available now in Live!

Get 1:1 Help Now