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

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