Adding a 3rd IF statement ??
From what you describe, I don't know where it should go in the formula. You
already have 2 IF statements, and for each one you have specified both a TRUE
and FALSE option. One of those options has to be replaced by another IF
statemewnt.
On Sat, 16 Oct 2004 21:00:46 -0500, yh73090
wrote:
Is it possible to add to this function a third "IF" statement?
If it is possible, How do I add "subtract DP11 if DM11 matches
J10:DA10"
=IF(OR(J$10$I$11,J$10<$H$11),"",IF(J$10=$H$11,$H $11,$H$11+((J$10-$H$11)/$H$4)*$H$4))
Thank you for all your help as always.
|