[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 725
  • 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
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 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

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

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