Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula Error
I seem to be incurring an error when trying to create an IF formula.
The formula is as follows: =IF(D1=0,E1,D10.01,B30*D1) Basically, the argument is that if I produce my quote in a foreign currency, the cell where the price appears looks to reference D1 to see if there is a foreign currency. If it says 0, there's not - if it is a value greater than 0.01 there is, then it has to take the cell where the price is, in this case B30 and multiply it by the value in D1 What am I doing wrong?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Error | Excel Worksheet Functions | |||
Error in Formula | Excel Discussion (Misc queries) | |||
How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
Formula Error | Excel Worksheet Functions | |||
Error in a formula | Excel Discussion (Misc queries) |