Posted to microsoft.public.excel.worksheet.functions

BobVA

Posts: n/a

writing a greater than/less than formula

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula for selecting the greater of two values?	Boriana	Excel Worksheet Functions	6	April 5th 23 01:05 PM
Matching Values from an Array	Mal	Excel Worksheet Functions	2	January 4th 06 10:06 AM
Greater than formula!	nekteo	Excel Worksheet Functions	2	December 29th 05 05:09 PM
Need Help Writing a Formula	Lynn	Excel Worksheet Functions	11	September 11th 05 07:51 PM
Help writing an Excel Formula	bella0711	Excel Worksheet Functions	4	September 9th 05 03:57 PM

All times are GMT +1. The time now is 03:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us