I am in the process of converting data from an excel spreadsheet into an Access database.
The formula I use in the excel spreadsheet looks like this:
=IF(B30>0,8-(B30*0.1),0)

I have made numerous attempts to recreate this in Access using the IIf expression to no avail. Can someone please give some guidance on writing this for my access database.

Thank you so much for any assistance you can offer.
Splash

What does B30 represent?

Assuming that =IF(B30>0,8-(B30*0.1),0) is a typo, and that you really intended =IIF(B30>0,8-(B30*0.1),0), there's nothing wrong with the formula, other than knowing what B30 represents.

You can test it out in the debug window thusly:

B30 = 6
? IIF(B30>0,8-(B30*0.1),0)
7.4

B30 represented the cell in the excel spreadsheet. In my access database it would represent my field 1st Titration.

I did use your suggestions and it worked. I'm not sure what I was doing wrong previously. Thank you so much for your kind assistance.