more trouble with IF stmt!!

E

Elena

Can anyone help
could someone please scroll down a few lines to "trouble with an if stmt"? I have further ?'s and I didnt think anyone would look at an old posting and didnt want to re-type all the info. Please read all comments.
 
B

BrianB

I prefer to adapt Leo's method :-

=IF(A1="","",IF(ISERROR(HLOOKUP(A1,{"E","L","C","M";0.1,0.1,0.01,0.001},2,0)),"error",ROUND(HLOOKUP(A1,{"E","L","C","M";0.1,0.1,0.01,0.001},2,0)*D1*C1,2))
 

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

How to set tabs in work document 0
Autonumber field in Excel that behaves the same as Access 0
Word doc keeps changing to ALL CAPS 0
Working on birthday "book" for my wife and having layout/editing trouble 0
Automation of scanned file storage based on content 0
Left, Right, Mid in Forms VB Coding 11
Code Execution Interrupted ?? 1
180-degree Rotate template 0

Top