# If formula

#### Vegaanders

##### New Member
Hi all! Newbi here

I need a formula that checks a value in a cell. In cell B it should add 10% to the value in Cell A. But if the 10% is less then 2 it should add 2 instead

Hope someone understand

Regards
Anders Yuran

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Hi,

an attempt

=A2+MAX(A2*10%,2)

Regards

Hi,

an attempt

=A2+MAX(A2*10%,2)

Regards

Sorry but not working.

Anders

Perhaps this is easier to understand.

If 10% of the value of A1 is >2 then add the value else add 2

Anders

Hi,

this segment if A1*10% is >2 adds A1 (the value) else adds 2

=MAX((A1*10%>2)*A1,2)

Hope it helps

Regards

Hi,

this segment if A1*10% is >2 adds A1 (the value) else adds 2

=MAX((A1*10%>2)*A1,2)

Hope it helps

Regards

Have you really tested that? When I implement I get error. And the explanation for max is different MAX(number1, [number2], ...)

I put 10 in A1 and the formula in B1. In B1 should the be 12 but get error

Anders

Try

=A1+MAX(A1/10,2)

Hi,

sorry VoG, i did not mean to overlap.

Last edited:
Still error. It points at the second part A1,2 as the problem

Maybe Excel uses ; as delimiter

A1+MAX(A1/10;2)

Replies
9
Views
598
Replies
3
Views
486
Replies
0
Views
218
Replies
15
Views
408
Replies
3
Views
310

1,196,487
Messages
6,015,502
Members
441,898
Latest member
kofafa

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back