J
James Hamilton
I have an IF statement that looks up the value in a cell, and returns one of
two values in other cells. It is:
=IF((OR(H9>10%,H9<-20%)),$B$40,$B$39)
i.e. if H9 is either greater than 10% or less than or equal to -20%, return
the contents of cell B40. If not, return the contents of B39. So far so good.
Sometimes the contents of H9 is blank (formula in H9 is
=IF(G9=0,"",((F9-G9)/G9)).
i.e. if G9 is zero, return a blank (" ").
My problem is that the above should return the contents of cell B39 (cause
it's NOT greater than 10% or less than or equal to -20%), but it doesn't; it
returns the contents of B40. HELP!
Thanks for taking the time to read this.
two values in other cells. It is:
=IF((OR(H9>10%,H9<-20%)),$B$40,$B$39)
i.e. if H9 is either greater than 10% or less than or equal to -20%, return
the contents of cell B40. If not, return the contents of B39. So far so good.
Sometimes the contents of H9 is blank (formula in H9 is
=IF(G9=0,"",((F9-G9)/G9)).
i.e. if G9 is zero, return a blank (" ").
My problem is that the above should return the contents of cell B39 (cause
it's NOT greater than 10% or less than or equal to -20%), but it doesn't; it
returns the contents of B40. HELP!
Thanks for taking the time to read this.