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:
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") ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Perfect and ultrafast;)
Thanks all
Thanks all
@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
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
try
=IF(isblank(O39);""if(O39;
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