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