If formula

[Vegaanders]

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

 

[Canapone]

Hi,

an attempt

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


Regards

 

[Vegaanders]

Hi,

an attempt

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


Regards

Sorry but not working.

Anders

 

[Vegaanders]

Perhaps this is easier to understand.

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

Anders

 

[Canapone]

ADVERTISEMENT

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

 

[Vegaanders]

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

 

[VoG]

ADVERTISEMENT

Try

=A1+MAX(A1/10,2)

 

[Canapone]

Hi,

sorry VoG, i did not mean to overlap.

 

[Vegaanders]

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

 

[Canapone]

Maybe Excel uses ; as delimiter

A1+MAX(A1/10;2)