[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 723
  • Last Modified:

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

0
agepab
Asked:
agepab
3 Solutions
 
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
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Sorry, missed a ;

corrected:

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

0
 
cyberkiwiCommented:
Do semicolons work?
Anyway, I use

=if(039="","",if(o39,"Fakturert","Opptjent"))
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
barry houdiniCommented:
try

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

Regards, barry
0
 
agepabAuthor 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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now