Howdy!
I am working on a form and need some answers please.
Fields are as follows;

[Quanity1]
[Description1]
[Price1]
>>>>then
[Quanity2]
[Description2]
[Price2]
>>>>then


[Total]

Here is what I've done
=IIf([Description1]="Night",[Quanity1]*24)

This works fine but here is what I'm trying to do:
=IIf([Description1]="Night",[Quanity1]*24)
And IIf([Description1]="Week",[Quanity1]*120)
And IIf([Description1]="Month",[Quanity1]*330)
And IIf([Description1]="Storage",[Quanity1]*30)

If this can be done, I'd like the results to Price1 and Price2
to culminate in [Total]

Any help for me?