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