Create an IF THEN formula in Excel 2007 1

[BlueHorizon]

Hi everyone!

Here's my question:

I have the value 250 in a cell. If the value is <=200, I want to multiply the value by 2. If the value is >=200, I want the multiply the first 200 by 2 and I want to multiply whatever is >200 by .5

Any help in constructing this formula is welcome and appreciated!

TIA,


Best,
Blue Horizon

 

[SkipVought]

hi,
have the value 250 in a cell. If the value is <=200, I want to multiply the value by 2. If the value is >=200, I want the multiply the first 200 by 2 and I want to multiply whatever is >200 by .5

Assuming that the value is in A1...
[tt]
=if(a1<=200,a1*2,(a1-200)*.5+400)
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[BlueHorizon]

Thanks so much, Skip! You da' bomb! Works like a charm!

HAGD,
Kathy

Best,
Blue Horizon

 

[mscallisto]

Note:

If the value is <=200 do something
If the value is >=200 do something else

In both cases you have the value = 200, that usually doesn't work.

Usually it's <=200 with > 200
Or <200 with >=200

sam