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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula Error
Maybe...
=IF(D1=0,E1,B30*D1) Ben wrote: 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?? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula Error
Hi ben
Try =IF(D1=0,E1,IF(D10.01,E1,B30*D1)) HTH Michael M "Ben" wrote: 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?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula Error
Hi Michael,
I copied that in and although it doesn't come up with the forumla error, when there is a value in cell D1 that's above 0.01, it's not carrying out the B30*D1. Any suggestions? Maybe it needs a different forumla to IF? Cheers, Ben "Michael M" wrote: Hi ben Try =IF(D1=0,E1,IF(D10.01,E1,B30*D1)) HTH Michael M "Ben" wrote: 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?? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula Error
Your formula is written so that if D10.01, the result is E1, not B30*D1.
Do you want: =IF(D10.01,B30*D1,E1) ??? In article , Ben wrote: Hi Michael, I copied that in and although it doesn't come up with the forumla error, when there is a value in cell D1 that's above 0.01, it's not carrying out the B30*D1. Any suggestions? Maybe it needs a different forumla to IF? Cheers, Ben "Michael M" wrote: Hi ben Try =IF(D1=0,E1,IF(D10.01,E1,B30*D1)) HTH Michael M "Ben" wrote: 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?? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula Error
On May 6, 2:26 pm, Ben wrote:
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) Perhaps this is what you were trying to write: =if(or(D1=0,D1<=0.01), E1, B30*D1) But note that that can be simplied to just: =if(D1<=0.01, E1, B30*D1) |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula Error
It still wont multiply the value in B30 by the value in D1 when there is a
value in D1! "joeu2004" wrote: On May 6, 2:26 pm, Ben wrote: 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) Perhaps this is what you were trying to write: =if(or(D1=0,D1<=0.01), E1, B30*D1) But note that that can be simplied to just: =if(D1<=0.01, E1, B30*D1) |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula Error
Ben
All of the attached formulae work in their respective ways. Maybe you could post a sample of what you actually want and let us re-assess Also, check to formatting of your cells to make sure they are all formatted as numbers. HTH Michael M "Ben" wrote: It still wont multiply the value in B30 by the value in D1 when there is a value in D1! "joeu2004" wrote: On May 6, 2:26 pm, Ben wrote: 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) Perhaps this is what you were trying to write: =if(or(D1=0,D1<=0.01), E1, B30*D1) But note that that can be simplied to just: =if(D1<=0.01, E1, B30*D1) |
Reply |
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) |