Thread: Nesting Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DSCAVOTTO
 
Posts: n/a
Default 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