create a formula with several variables

  • Thread starter Thread starter monica \(deletethis\)
  • Start date Start date
M

monica \(deletethis\)

i need to calculate the value of a cell using the
following parameters

if A1 is<=10, sum(A1 + 1)
if A1 is>9, SUM(A1 * 1.2)
IF A1 IS >20, SUM(A1 * 1.15)
how do i write this formula to work

thanks a lot for the information
 
John,

Are you reading *between* the lines of the OP ?

The second stipulation states "if A1 is greater then 9, multiply A1 by 1.2",
Which is more or less *contradicting* the first stipulation of,
"if A1 is equal to or less then 10, add 1 to A1".

How did you reason out your suggested formula ?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


monica,

Try this out:

=IF(A1<=10,A1+1,IF(A1<=20,A1*1.2,A1*1.5))

John
 
RD,

Ya' know......

Now that I looked at it again, I see your point.
Yes, there is a definite contradiction there.
Sometimes the OP's don't really know what they want. <vbg>

I would hope that monica gets the general construct of
how to embed the "IF's" and correct her contradiction
on her own.
How did you reason out your suggested formula
Click to expand...
Pulled it out of thin air without thinking it through, obviously.

John
 
Back
Top