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