Excel Formula-to Access?

M

Marquis

I have an excel spreadsheet that I am building a database
for. I have a formula: =IF(B8="","", IF(E8>0,0,IF(D8=0,1,IF
(D8=1,0.5,0)))).....that I don't know how to approach in
Access. Also, the cells are field names in access. I tried
IIf, but that did not work. Any thoughts?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
Autonumber field in Excel that behaves the same as Access 0
Excel Formula in Access? 2
Formula Help 0
Excel - Wich Function should I use? 1
Mail Merge Directory Conditional Page Break 0
#VALUE! Error 3
What formula should I use to extract multiple data from one column 2

Top