Quick Formula Hlep

[sleepymum]

Hi,

Can anyone please help me to write this formula:

If A1 is greater than or equal to 1 multiple by 5%
If A1 is less than or equal to 10 multiply by 10%


Thanks in advance!

 

[RichardMGreen]

=if(A1<=10,A1*1.1,if(A1>=1,A1*1.05,A1))

This will give you an increase of the required percentage. If you just want 5% or 10% of the value then change to 0.1 and 0.05.
It will also only give one or the other. You didn't specify what to do if neither condition is met so it will just display the contents of A1.

 

[Ruddles]

What A1 is equal to 5? Do both?

What if it's less than 1 or greater than 10? Do neither?

 

[sleepymum]

Sorry this should make it clearer!!!
If A1 is greater than 356 multiple by 10.75%
If A1 is less than or equal to 356 multiply by 8.55%


Again thanks for help!

 

[RichardMGreen]

=if(A1>365,A1*1.1075,if(A1<=365,A1*1.0855,A1))

Try that.

 

[cb12]

Try

=IF(A1<=356,A1*0.0855,A1*0.1075)

Adjust as required.