more trouble with IF stmt!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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))
 
Back
Top