Reply
Tue 13 Aug, 2013 01:39 pm
Good day
I have a nested if that is not working, my fault, if C" has a phrase "Nonbillable" then the cell with the formula will show NO, if it displays any other text it will display YES and if C" is empty it will display C2 (as it is empty), it is the empty bit that I think I have wrong.
My formula attempt is :-
=IF(C2="Nonbillable",if (c2="",c2"NO"),"YES")
Could some one please help.
@rosuco,
You've got the arguments backwards. The form is
If (condition, true, false)
Yours should be =IF(C2="Nonbillable","NO",if (c2="",c2,"YES"))
@engineer,
Engineer, my thanks, you can tell I am just a novice.
@rosuco,
I have used a formula as supplied by engineer (my thanks) but again I must be looking through fog, when I entered the formula all works as I need but when a cell in the C column is empty it is displaying a zero instead of a empty blank cell which is what I thought the double quotes did.
Any help in how to get a blank empty cell with the formula would be appreciated.
@rosuco,
It's using the value of C2 which is zero. Change to =IF(C2="Nonbillable","NO",if (c2="",
"","YES"))
@engineer,
Not much to say engineer, except perfect. My thanks for your time and trouble.