Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ridash
 
Posts: n/a
Default minimum


hi

how can i do the following equation?


40$ if the sum is less than 1000$
75$ if the sum is less than 1001$ t0 3000$
100$ if the sum is less than 3001$
3001$ and up no minimum

all should go in one cell

thanks
Rida


--
ridash
------------------------------------------------------------------------
ridash's Profile: http://www.excelforum.com/member.php...o&userid=35617
View this thread: http://www.excelforum.com/showthread...hreadid=554015

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Second highest minimum in a group Jennifer Excel Worksheet Functions 1 March 6th 06 09:34 PM
minimum from various columns without zeroes joie Excel Worksheet Functions 5 November 29th 05 05:49 AM
second minimum value Ken Excel Discussion (Misc queries) 3 March 16th 05 06:17 PM
Hiding Values Below Z Axis Minimum Value on Axis Charts TryingToExcel Charts and Charting in Excel 1 February 18th 05 03:55 AM
Sum minimum values in a pivot table AK Excel Worksheet Functions 1 December 22nd 04 08:55 PM


All times are GMT +1. The time now is 02:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"