T
TommyB
I an trying to use an IF function in a cell (lets say U83) but I do not want
to use the function if cell R83 is blank. As a matter of fact I want to
return a value of "N/A" in cell U83 if R83 is blank. This is The IF function
I used:
=IF(R83=" ","N/A",IF(S83>R83,"N","1"))
Problem is that when R83 IS blank, the answer being returned in cell U83 is
"N" which comes from the second IF function. I want the first part of the IF
function to take precedent.
What am I doing wrong?
Thanks...TommyB
to use the function if cell R83 is blank. As a matter of fact I want to
return a value of "N/A" in cell U83 if R83 is blank. This is The IF function
I used:
=IF(R83=" ","N/A",IF(S83>R83,"N","1"))
Problem is that when R83 IS blank, the answer being returned in cell U83 is
"N" which comes from the second IF function. I want the first part of the IF
function to take precedent.
What am I doing wrong?
Thanks...TommyB