RE: if formulas
- From: Joel <Joel@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 12 Apr 2008 21:50:00 -0700
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
- References:
- if formulas
- From: Sue
- RE: if formulas
- From: Mike Rogers
- RE: if formulas
- From: Sue
- RE: if formulas
- From: Mike Rogers
- RE: if formulas
- From: Sue
- if formulas
- Prev by Date: RE: if formulas
- Next by Date: Excel Charting Problem
- Previous by thread: RE: if formulas
- Next by thread: RE: if formulas
- Index(es):
Relevant Pages
|
