S
SplashDesigns
Guest
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
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