Is this a legal formula?

  • Thread starter Thread starter Julie P.
  • Start date Start date
J

Julie P.

Hi, I have the following formula:

=IF(Q3<=25,Q3*0.0525,1.3125+(Q3-25)*0.0275)

Now, what I want to do, is take the result of the above formula, and times
it by an integer I have in cell R3. But I want this formula, and the one
above, in one cell, not two. So can I do the following:

=R3*(IF(Q3<=25,Q3*0.0525,1.3125+(Q3-25)*0.0275))

Thanks!
 
Julie P. said:
Hi, I have the following formula:

=IF(Q3<=25,Q3*0.0525,1.3125+(Q3-25)*0.0275)

Now, what I want to do, is take the result of the above formula, and times
it by an integer I have in cell R3. But I want this formula, and the one
above, in one cell, not two. So can I do the following:

=R3*(IF(Q3<=25,Q3*0.0525,1.3125+(Q3-25)*0.0275))
Click to expand...


ok, never mind. I tried the above, and it appears to work. I thought for
some reason that "if" always had to be to the direct right of the equal
sign. Don't know why now.
 
Julie,

Before I read this one, I was going to reply along the lines of why don't
you try it? <vbg>

If returns a result, a value, or maybe TRUE/FALSE, so it is perfectly
feasible to embed that within the overall function, operating upon it the
same way as say

=A2*B2


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top