Is this possible

[xgk]

Would the following formula be possible in one cell, using A5 as the cell with a figure in?
IF A5>1, SUM A5*10%, AND IF A5<1, SUM A5*20%

[MarvinP]

Hi xgk and welcome to the forum,

I think you are looking for something like:
=IF(A5>1,A5*1.1,IF(A5<1,A5*1.2,"A5 = 1"))

see the attached:
Double If Formula.xlsx

[Mazzaropi]

xgk, Good evening.

Try to use: =A5*(IF(A5>1,1.1,IF(A5<1,1.2,1)))

Is that what you want?

I hope it helps.

[jeffreybrown]

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed…
• Please see Forum Rule #1 about proper thread titles and adjust accordingly...