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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 01:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com