OR Function Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=IF(OR(F32=0,F32=""),0,F32/$F$37

When I use this function, if I put 0 in F32 it populates 0.00% then when I put "" in F32 it populates #VALUE!. At this point, I would like it to populate 0.00% as answer when either "" or 0 put in F32 and all other numbers do the formula of F32/$F$37.

I hope you can figure this out for me. Please provide me the formula to solve this problem

anonymou
 
Putting "" in a cell is not the same as the cell = ""

This denotes that it is blank, and if it is blank then your formula works fine
for me. A blank, or "" being returned by a formula will evaluate as you expect.
Actually typing in "" to a cell will not, and gives the #VALUE error you
describe.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



anonymous said:
=IF(OR(F32=0,F32=""),0,F32/$F$37)

When I use this function, if I put 0 in F32 it populates 0.00% then when I put
Click to expand...
"" in F32 it populates #VALUE!. At this point, I would like it to populate
0.00% as answer when either "" or 0 put in F32 and all other numbers do the
formula of F32/$F$37.
 
Hi
I made an addition :-)
use
=IF(OR(F32=0,F32="",NOT(ISNUMBER(F32))),0,F32/$F$37)

Note: there is a difference between entering "" or ="" in a cell. the
previous formula only checks for the latter one
 
How about...

=IF(N(F32)*N($F$37),F32/$F$37,0)

anonymous said:
=IF(OR(F32=0,F32=""),0,F32/$F$37)

When I use this function, if I put 0 in F32 it populates 0.00% then when I
Click to expand...
put "" in F32 it populates #VALUE!. At this point, I would like it to
populate 0.00% as answer when either "" or 0 put in F32 and all other
numbers do the formula of F32/$F$37.
 
Back
Top