Is it possible to add to this function a third "IF" statement?

If it is possible, How do I add "subtract DP11 if DM11 matche
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

--
yh7309
-----------------------------------------------------------------------
yh73090's Profile: http://www.excelforum.com/member.php...nfo&userid=751
View this thread: http://www.excelforum.com/showthread.php?threadid=26990

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.

My best guess is you wanted to add that feature to the 2nd IF..False
argument.

=IF(OR(J$10$I$11,J$10<$H$11),"",IF(J$10=$H$11,$H$ 11,IF(COUNTIF($J$10:$DA$10
,$DM$11)0,$H$11+((J$10-$H$11)/$H$4)*$H$4-$DP$11,$H$11+((J$10-$H$11)/$H$4)*$
H$4)))

Mike F
"yh73090" wrote in message
...

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.


--
yh73090
------------------------------------------------------------------------
yh73090's Profile:
http://www.excelforum.com/member.php...fo&userid=7510
View this thread: http://www.excelforum.com/showthread...hreadid=269908

As a rule you can have up to 7 nested IF statements. The trick is to keep
track of the logic.
"yh73090" wrote in message
...

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.


--
yh73090
------------------------------------------------------------------------
yh73090's Profile:
http://www.excelforum.com/member.php...fo&userid=7510
View this thread: http://www.excelforum.com/showthread...hreadid=269908