Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a 3rd IF statement ??
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a 3rd IF statement ??
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a 3rd IF statement ??
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a statement to several documents | Excel Worksheet Functions | |||
Adding A Not(IsBlank) To IF Statement(help) | Excel Worksheet Functions | |||
Adding an AND Statement to COUNTIF | Excel Worksheet Functions | |||
adding if statement results | Excel Worksheet Functions | |||
Adding SQL Select Statement | Excel Programming |