| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if formulas
I am having problems with how to write this formula, any suggestions?
if F2 =3 then A2 times 250, if F2 = 2, then A2 times 50 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formulas
Sue
Try: =IF(F2=3,A2*250,IF(F2=2,A2*50,"")) Mike Rogers "Sue" wrote: I am having problems with how to write this formula, any suggestions? if F2 =3 then A2 times 250, if F2 = 2, then A2 times 50 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formulas
=IF(F2=2,A2*50,IF(F2=3,A2*250,""))
best wishes Sreedhar "Sue" wrote: I am having problems with how to write this formula, any suggestions? if F2 =3 then A2 times 250, if F2 = 2, then A2 times 50 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formulas
Try this:
=A2*((F2=3)*250+(F2=2)*50) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Sue" wrote in message ... I am having problems with how to write this formula, any suggestions? if F2 =3 then A2 times 250, if F2 = 2, then A2 times 50 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formulas
That works except my data in Cell F2 is coming in as text from data source, is there a way in the formula to write it so it is reading the text instead of number. I know I can write a macro to convert to numbers, but is there an easy way to do in formula?? "Mike Rogers" wrote: Sue Try: =IF(F2=3,A2*250,IF(F2=2,A2*50,"")) Mike Rogers "Sue" wrote: I am having problems with how to write this formula, any suggestions? if F2 =3 then A2 times 250, if F2 = 2, then A2 times 50 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formulas
Sue
Put what is in TEXT in doulble quotes and it will work! =A2*((F2="3")*250+(F2="2")*50) Mike Rogers "Sue" wrote: That works except my data in Cell F2 is coming in as text from data source, is there a way in the formula to write it so it is reading the text instead of number. I know I can write a macro to convert to numbers, but is there an easy way to do in formula?? "Mike Rogers" wrote: Sue Try: =IF(F2=3,A2*250,IF(F2=2,A2*50,"")) Mike Rogers "Sue" wrote: I am having problems with how to write this formula, any suggestions? if F2 =3 then A2 times 250, if F2 = 2, then A2 times 50 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formulas
Thanks so much, you saved me hours of work.
"Mike Rogers" wrote: Sue Put what is in TEXT in doulble quotes and it will work! =A2*((F2="3")*250+(F2="2")*50) Mike Rogers "Sue" wrote: That works except my data in Cell F2 is coming in as text from data source, is there a way in the formula to write it so it is reading the text instead of number. I know I can write a macro to convert to numbers, but is there an easy way to do in formula?? "Mike Rogers" wrote: Sue Try: =IF(F2=3,A2*250,IF(F2=2,A2*50,"")) Mike Rogers "Sue" wrote: I am having problems with how to write this formula, any suggestions? if F2 =3 then A2 times 250, if F2 = 2, then A2 times 50 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formulas
Another way is to change the number to text
=A2*((value(F2)=3)*250+(value(F2)=2)*50) The solution that make gave works only if you are looking for the numbers to exactly equal a value. If you needed a number greater or less then you need my solution for example =if(value(F2)=3,true,false) "Sue" wrote: Thanks so much, you saved me hours of work. "Mike Rogers" wrote: Sue Put what is in TEXT in doulble quotes and it will work! =A2*((F2="3")*250+(F2="2")*50) Mike Rogers "Sue" wrote: That works except my data in Cell F2 is coming in as text from data source, is there a way in the formula to write it so it is reading the text instead of number. I know I can write a macro to convert to numbers, but is there an easy way to do in formula?? "Mike Rogers" wrote: Sue Try: =IF(F2=3,A2*250,IF(F2=2,A2*50,"")) Mike Rogers "Sue" wrote: I am having problems with how to write this formula, any suggestions? if F2 =3 then A2 times 250, if F2 = 2, then A2 times 50 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formulas
ok, 1 last question, when the value in F3 is blank it returns a value of
false, I would like it to show 0 or blank. This is the formula I entered but it errors out. =IF(iserror(if(F3="02",A3*250,IF(F3="03",A3*250)), 0,=IF(F3="02",A3*250,IF(F3="03",A3*250)) =IF(F3="02",A3*250,IF(F3="03",A3*250)) "Mike Rogers" wrote: Sue Put what is in TEXT in doulble quotes and it will work! =A2*((F2="3")*250+(F2="2")*50) Mike Rogers "Sue" wrote: That works except my data in Cell F2 is coming in as text from data source, is there a way in the formula to write it so it is reading the text instead of number. I know I can write a macro to convert to numbers, but is there an easy way to do in formula?? "Mike Rogers" wrote: Sue Try: =IF(F2=3,A2*250,IF(F2=2,A2*50,"")) Mike Rogers "Sue" wrote: I am having problems with how to write this formula, any suggestions? if F2 =3 then A2 times 250, if F2 = 2, then A2 times 50 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formulas
Your IF have a true and false response. You left the false results blank
giving the False. I put zero in the formula to give a zero results. =IF(iserror(if(F3="02",A3*250,IF(F3="03",A3*250,0) ),0,=IF(F3="02",A3*250,IF(F3="03",A3*250,0)) =IF(F3="02",A3*250,IF(F3="03",A3*250,0)) "Sue" wrote: ok, 1 last question, when the value in F3 is blank it returns a value of false, I would like it to show 0 or blank. This is the formula I entered but it errors out. =IF(iserror(if(F3="02",A3*250,IF(F3="03",A3*250)), 0,=IF(F3="02",A3*250,IF(F3="03",A3*250)) =IF(F3="02",A3*250,IF(F3="03",A3*250)) "Mike Rogers" wrote: Sue Put what is in TEXT in doulble quotes and it will work! =A2*((F2="3")*250+(F2="2")*50) Mike Rogers "Sue" wrote: That works except my data in Cell F2 is coming in as text from data source, is there a way in the formula to write it so it is reading the text instead of number. I know I can write a macro to convert to numbers, but is there an easy way to do in formula?? "Mike Rogers" wrote: Sue Try: =IF(F2=3,A2*250,IF(F2=2,A2*50,"")) Mike Rogers "Sue" wrote: I am having problems with how to write this formula, any suggestions? if F2 =3 then A2 times 250, if F2 = 2, then A2 times 50 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formulas
Your formula seems to be an OR condition:
If F3 is either 02 or 03 then multiply A3 by 250. Try this: =IF(F3="","",IF(OR(F3={"02","03"}),A3*250,"")) -- Biff Microsoft Excel MVP "Sue" wrote in message ... ok, 1 last question, when the value in F3 is blank it returns a value of false, I would like it to show 0 or blank. This is the formula I entered but it errors out. =IF(iserror(if(F3="02",A3*250,IF(F3="03",A3*250)), 0,=IF(F3="02",A3*250,IF(F3="03",A3*250)) =IF(F3="02",A3*250,IF(F3="03",A3*250)) "Mike Rogers" wrote: Sue Put what is in TEXT in doulble quotes and it will work! =A2*((F2="3")*250+(F2="2")*50) Mike Rogers "Sue" wrote: That works except my data in Cell F2 is coming in as text from data source, is there a way in the formula to write it so it is reading the text instead of number. I know I can write a macro to convert to numbers, but is there an easy way to do in formula?? "Mike Rogers" wrote: Sue Try: =IF(F2=3,A2*250,IF(F2=2,A2*50,"")) Mike Rogers "Sue" wrote: I am having problems with how to write this formula, any suggestions? if F2 =3 then A2 times 250, if F2 = 2, then A2 times 50 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formulas
=IF(F3="","",IF(OR(F3={"02","03"}),A3*250,""))
That can be reduced to: =IF(OR(F3={"02","03"}),A3*250,"") -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Your formula seems to be an OR condition: If F3 is either 02 or 03 then multiply A3 by 250. Try this: =IF(F3="","",IF(OR(F3={"02","03"}),A3*250,"")) -- Biff Microsoft Excel MVP "Sue" wrote in message ... ok, 1 last question, when the value in F3 is blank it returns a value of false, I would like it to show 0 or blank. This is the formula I entered but it errors out. =IF(iserror(if(F3="02",A3*250,IF(F3="03",A3*250)), 0,=IF(F3="02",A3*250,IF(F3="03",A3*250)) =IF(F3="02",A3*250,IF(F3="03",A3*250)) "Mike Rogers" wrote: Sue Put what is in TEXT in doulble quotes and it will work! =A2*((F2="3")*250+(F2="2")*50) Mike Rogers "Sue" wrote: That works except my data in Cell F2 is coming in as text from data source, is there a way in the formula to write it so it is reading the text instead of number. I know I can write a macro to convert to numbers, but is there an easy way to do in formula?? "Mike Rogers" wrote: Sue Try: =IF(F2=3,A2*250,IF(F2=2,A2*50,"")) Mike Rogers "Sue" wrote: I am having problems with how to write this formula, any suggestions? if F2 =3 then A2 times 250, if F2 = 2, then A2 times 50 |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if formulas
Thanks so much, if any of you are in Dallas, Tx Area or St Louis Area let me
know I owe you dinner. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Linear Mode
