Hi i have a problem with this simple IF statement,

what i want is to calculate one amount (90) for 0-3hrs then multiply by (30)

So the charge for 1,2 or 3 hours will be £90 but then 4 hours £120, 5 hours
£150 etc.

What I have so far is:

=if(N95<=3,90,N95*30) This works fine except if the total in N95 is 0 it is
still showing a charge of £90 which should be £0.00.

Any help on this would be great as i haven't used IF statements in ages.

=IF(N95=0,0,IF(N95<=3,90,N95*30))

or even better

=IF(N95=0,0,IF(AND(N95<=3,90,N950),90,N95*30))

oops, sorry, should be:

=IF(N95=0,0,IF(AND(N95<=3,N950),90,N95*30))

=if(N95=0,0,IF(N95<=3,90,N95*30))

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Joe" escreveu:

Hi i have a problem with this simple IF statement,

what i want is to calculate one amount (90) for 0-3hrs then multiply by (30)

So the charge for 1,2 or 3 hours will be £90 but then 4 hours £120, 5 hours
£150 etc.

What I have so far is:

=if(N95<=3,90,N95*30) This works fine except if the total in N95 is 0 it is
still showing a charge of £90 which should be £0.00.

Any help on this would be great as i haven't used IF statements in ages.

Another approach:
=IF(AND(N950,N95<=3),90,N95*30)

Regards,
Stefi

€žJoe€� ezt Ã*rta:

Hi i have a problem with this simple IF statement,

what i want is to calculate one amount (90) for 0-3hrs then multiply by (30)

So the charge for 1,2 or 3 hours will be £90 but then 4 hours £120, 5 hours
£150 etc.

What I have so far is:

=if(N95<=3,90,N95*30) This works fine except if the total in N95 is 0 it is
still showing a charge of £90 which should be £0.00.

Any help on this would be great as i haven't used IF statements in ages.