Thread: IF
View Single Post
  #1   Report Post  
Micayla Bergen
 
Posts: n/a
Default IF

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