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

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

AageConsultantAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Sorry, missed a ;

corrected:

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

0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
cyberkiwiConnect With a Mentor Commented:
Do semicolons work?
Anyway, I use

=if(039="","",if(o39,"Fakturert","Opptjent"))
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
barry houdiniConnect With a Mentor Commented:
try

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

Regards, barry
0
 
AageConsultantAuthor Commented:
Perfect and ultrafast;)

Thanks all
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
@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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.