ExcelBanter - IF formula with subtraction

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - IF formula with subtraction (https://www.excelbanter.com/excel-programming/347064-if-formula-subtraction.html)

emily''''s excel

IF formula with subtraction

Last IF formula worked great.....

next IF formula that would follow would be: =IF(D9,"X")*("AB9"-"P9")

what I am trying to do....is IF D9 = X then the cell = AB9 - P9

--
Thanks

Toppers

IF formula with subtraction

Hi,

=IF(D9="X",AB9-P9,0)

puts in 0 if D9 < "X"

"emily''''s excel" wrote:

Last IF formula worked great.....

next IF formula that would follow would be: =IF(D9,"X")*("AB9"-"P9")

what I am trying to do....is IF D9 = X then the cell = AB9 - P9

--
Thanks

All times are GMT +1. The time now is 07:03 PM.