If value is greater than, then....

Hi,

I am trying to create a formula. Column A has a number
Column B is a sum of A*1,2 only if A is over 100 otherwise
B=A

Logic: If A1100 then B1=(A1*1,2); If A1=100 then B1=A1

How do I transfer this so that excel understands it??

Thanks in advance for your help
R

"Robert" wrote in message
...
Hi,

I am trying to create a formula. Column A has a number
Column B is a sum of A*1,2 only if A is over 100 otherwise
B=A

Logic: If A1100 then B1=(A1*1,2); If A1=100 then B1=A1

How do I transfer this so that excel understands it??

Thanks in advance for your help
R

I assume the comma in A1*1,2 is your decimal separator, so the parameter
separator will be a semicolon. If this is so, then in B1 the formula is
=IF(A1100;A1*1,2;A1)

[ I would normally wrte this formula as =IF(A1100,A1*1.2,A1) ]

Then copy the formula down column B as far as required.

Hi Robert

One way

In B1

=IF(A1100,A1*1.2,A1)

(or 1,2 instead of 1.2 and delimiter semicolon)

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

"Robert" skrev i en meddelelse
...
Hi,

I am trying to create a formula. Column A has a number
Column B is a sum of A*1,2 only if A is over 100 otherwise
B=A

Logic: If A1100 then B1=(A1*1,2); If A1=100 then B1=A1

How do I transfer this so that excel understands it??

Thanks in advance for your help
R

Hi R

Pretty close to what you wrote:
=IF(A1100,A1*1.2,A1)
IF functions are made like this
=IF(what to test, result if true, result if not)

You can also turn it this way
=A1+IF(A1100,A1*0.2,0)

or, another approach, just for the fun of it:
=A1+0,2*(A1100)*A1
=A1*(1+(A1100)/5)
since (A1100) returns either 0 or 1. Some of us finds this easier to read
and maintain than the IF things. But we're a minority, I believe :-)
--
HTH. Best wishes Harald
Excel MVP
Followup to newsgroup only please

"Robert" skrev i melding
...
Hi,

I am trying to create a formula. Column A has a number
Column B is a sum of A*1,2 only if A is over 100 otherwise
B=A

Logic: If A1100 then B1=(A1*1,2); If A1=100 then B1=A1

How do I transfer this so that excel understands it??

Thanks in advance for your help
R

Hi,

I dont know if this is the norm, but I would just like to
say thank you for all your replies. I have what I needed,
and some extras just for fun ;-)

Kindest regards
Robert

-----Original Message-----
"Robert" wrote in message
...
Hi,

I am trying to create a formula. Column A has a number
Column B is a sum of A*1,2 only if A is over 100
otherwise
B=A

Logic: If A1100 then B1=(A1*1,2); If A1=100 then B1=A1

How do I transfer this so that excel understands it??

Thanks in advance for your help
R

I assume the comma in A1*1,2 is your decimal separator,
so the parameter
separator will be a semicolon. If this is so, then in B1
the formula is
=IF(A1100;A1*1,2;A1)

[ I would normally wrte this formula as =IF
(A1100,A1*1.2,A1) ]

Then copy the formula down column B as far as required.


.

"Robert" wrote in message
...

I dont know if this is the norm, but I would just like to
say thank you

Unfortunately not, but highly appreciated when it happens. Glad everything worked, Robert,
welcome back anytime.

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.