ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF (https://www.excelbanter.com/excel-discussion-misc-queries/40555-if.html)

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

CLR

Maybe?......

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

Vaya con Dios,
Chuck, CABGx3

"Micayla Bergen" wrote in message
...
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

All times are GMT +1. The time now is 05:39 PM.