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