LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default formula in excell 2007

Ok, I am trying to create a formula that will do the following:

If cell F2 has any number between 23 and 28, I want it to multiply cell E2
by 20%,
if it has 28.01 and 32, then I want it to multiply cell E2 by 25%. If it has
32.01- 40, then I want cell E2 to multiply by 30%. And so on.
I only want it to do 5 sets of this.

Can anybody help?
please email me at
Thanks,

Jorge
 
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
How to open MS Excell 2007 Sheet in MS Excell 2000??? Alek Luchnikov New Users to Excel 1 March 22nd 07 04:40 PM
how do I set the print area in excell 2007 Wayne Excel Discussion (Misc queries) 2 January 31st 07 07:51 PM
Excell 2007 Beta privateicon New Users to Excel 2 December 21st 06 01:16 AM
Excell 2007???? Gklass Charts and Charting in Excel 12 July 31st 06 02:19 PM
HYPERLINKS IN EXCELL 2007 Bill Porter Excel Discussion (Misc queries) 0 June 1st 06 11:15 PM


All times are GMT +1. The time now is 09:55 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"