G
Guest
I have the following "If" statements that I want to nest.
=IF($H8<5,0)
=IF($H8>1,$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($H8>1,$G8),Q18),0))))
Any suggestions would be appreciated.
Thanks.
=IF($H8<5,0)
=IF($H8>1,$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($H8>1,$G8),Q18),0))))
Any suggestions would be appreciated.
Thanks.