IF

M

Micayla Bergen

IF(OR(($Z$14="reduce",$Z$15/3,""),($Z$14="acquire",$Z$15/-3,"")))

not sure how to polish that up so that the returned value is a positive
number if cell is 'reduce' or vice versa, and is blank if cell is neither
thank you
 
C

CLR

Maybe?......

=IF($Z$14="reduce",$Z$15/3,IF($Z$14="acquire",$Z$15/-3,""))

Vaya con Dios,
Chuck, CABGx3
 
Top