writing a greater than/less than formula

BobVA · 04-25-2006, 06:55 PM

Hello,

I'm ok in Excel but I need to write a formula to calculate that if sales are
greater than 100,000 but less than 200,000 multiply that number by 25%.
Probably real easy for some of you but I can't quite get it to work. Any
suggestion is welcome.

pdberger · 04-25-2006, 07:10 PM

Bob --

If your sales are in A1, then here's a formula that works:

=IF(AND(A2>100000,A2<200000),A2*1.25,"")

You'll need to add whatever happens if it's outside the range.

HTH

"BobVA" wrote:

> Hello,
>
> I'm ok in Excel but I need to write a formula to calculate that if sales are
> greater than 100,000 but less than 200,000 multiply that number by 25%.
> Probably real easy for some of you but I can't quite get it to work. Any
> suggestion is welcome.

Pete_UK · 04-25-2006, 07:10 PM

This raises a few other questions, such as what if sales are less than
or equal to 100,000 or greater than or equal to 200,000? But anyway,
you can try this, assuming the sales figure is in A1:

=IF(AND(A1>100000,A1<200000),A1*0.25,A1)

This returns A1 if the conditions are not met.

Hope this helps.

Pete

Fred Smith · 04-25-2006, 07:15 PM

Use the And function:

=if(and(a1>100000,a1<200000),a1*1.25,valueiffalse)

--
Regards,
Fred

"BobVA" <BobVA@discussions.microsoft.com> wrote in message
news:8F7FF437-89FE-4033-85DA-92AD049F12CA@microsoft.com...
> Hello,
>
> I'm ok in Excel but I need to write a formula to calculate that if sales are
> greater than 100,000 but less than 200,000 multiply that number by 25%.
> Probably real easy for some of you but I can't quite get it to work. Any
> suggestion is welcome.

**Zenaida** · 04-25-2006, 07:16 PM

I did not know what cell you wanted this formula in so you would need to replace A3 with the correct cell.

This formula should work but if the value is 100,000 it will not be multiplied by 25% because you state > 100000 and if the value is 200,000 it will not be multiplied by 25% because you state < 200000.

You will need to modify the formula if the values of 100,000 and 200,000 are suppose to be multiplied by 25%.

Also, if the value is greater than 200,000 and less than 100,000, what do you want the formula to do? With an If statement you have to tell the formula what you want when the result is true and what you want if the result is false. I did not know what you wanted to happen if the result was false. So I referenced the cell. So whatever is in cell A3 is what will appear in the cell that contains this formula.

Please Login or Register  to view this content.

MINI MART · 06-04-2006, 11:50 AM

"BobVA" wrote:

> Hello,
>
> I'm ok in Excel but I need to write a formula to calculate that if sales are
> greater than 100,000 but less than 200,000 multiply that number by 25%.
> Probably real easy for some of you but I can't quite get it to work. Any
> suggestion is welcome.

Corey · 06-04-2006, 08:35 PM

Try:
=IF(A1>200000,"",IF(A1<100000,"",IF(A1>=100000,A1*0.25)))

where A1 is your data.
Above formula will give a result if A1 is equal to 100,000 (min)and 200,000
(max)also.

If data is above or below range then nothing is displayed.

Corey....

"MINI MART" <MINI MART@discussions.microsoft.com> wrote in message
news:0C77A4C1-7183-4886-A8C0-9CE46DABA3D6@microsoft.com...
>
>
> "BobVA" wrote:
>
>> Hello,
>>
>> I'm ok in Excel but I need to write a formula to calculate that if sales
>> are
>> greater than 100,000 but less than 200,000 multiply that number by 25%.
>> Probably real easy for some of you but I can't quite get it to work. Any
>> suggestion is welcome.