create a formula with several variables

[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 Wilson]

monica,

Try this out:

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

John

 

[RagDyer]

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