Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting Formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting Formula
Not very clear about all possibilities but try
=IF($H8=5,$G8*($H8-$E8+1),=IF($H81,$G8,0)) -- Don Guillett SalesAid Software "DSCAVOTTO" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting Formula
What do you want to do if $H8 = 2,3, or 4? You have 2 options.
"DSCAVOTTO" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting Formula
=if($h8=5,$g8*($h8-$e8+1),if($h8<5,0,if($h81,$g8,0))) -- C01d ------------------------------------------------------------------------ C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422 View this thread: http://www.excelforum.com/showthread...hreadid=544347 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting Formula
This is a revenue recognition model. Revenue is not recognized until the
invoice is paid which is noted in column H. Column H reflects the month the invoice was paid, if it wasn't paid it is zero. If the invoice was booked in Janaury but not paid until May (month 5), then Jan-Apr are zero if which is the first formula listed below. The third formula is the catchup calculation of revenue earned with column E = to the month number the invoice was booked. Booked in Jan, paid in May (5-1+1) times the monthly prorated amount in column G. The middle formula records the prorated revenue amount if the invoice was paid but the month is after the month the invoice was paid (June - December) thnaks for your help. Dave "Barb Reinhardt" wrote: What do you want to do if $H8 = 2,3, or 4? You have 2 options. "DSCAVOTTO" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |