| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
