Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have the following "If" statements that I want to nest.
=IF($H8<5,0) =IF($H81,$G8,0) =IF($H8=5,$G8*($H8-$E8+1),0) The three statements by themselves work fine. I have ended up with the following nested statement which gives me a formula error. I have changed the number of brackets without success. =IF($H8=5,$G8*($H8-$E8+1)),if($H8<5,0),IF($H81,$G8),Q18),0)))) Any suggestions would be appreciated. Thanks. -- Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
assign formula to another cell | Excel Worksheet Functions | |||
Nesting the SUBSTITUTE formula | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel |