Access version of these Excel formulas?

[Rich_B]

Hi

I am in the process of converting my quotes and invoicing system from Excel to Access. As I input data into my table fields in Excel the formulas make the calculations in real time and tell me the price for my products dependent on the length, width, height and material fields.

I need to convert these formulas to Access. Any advice much appreciated.

=SUM(H14*G14*F14/1000000000*35.32)*O14

=M14*C14

=IF(E14="SD","2200",IF(E14="WC","2400",IF(E14="GRC","452",IF(E14="NAT","2500","Material Not Selected"))))

=IF(E14="","Material Not Selected",I14*C14)

=IF(E14="","Material Not Selected",(F14*G14*H14/1000000000)*C14)

=SUM(N13:N19)

=IF(P14<>"Material Not Selected",SUM(F14*G14*H14*P14/1000000000),IF(E14="","","N/A"))

=((M14/100)*$N$23)+M14

Thank you.

 

[arnelgp]

create a named range in excel, same field name in your table, then we can evaluate your formula.