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 I think I need a multiple IF statement, or is there another way?

I can do the simple stuff, but this is more complicated!

In English, this is what I want to do

If the number in [cell] is <=X then take off %
then
If the number in [cell] is <=Y then take off a further %
then
If the number in [cell] is <=Z then take off a further %
then
Display result

It's probably as nested IF statement, but I don't know how to construct it.

Thanks.
 
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
If statement with multiple criteria and multiple results Tickfarmer Excel Discussion (Misc queries) 3 January 28th 09 08:11 PM
Multiple IF statement Dave in Ampthill[_2_] New Users to Excel 4 December 12th 08 12:44 AM
Multiple If statement John Gregory Excel Discussion (Misc queries) 8 October 10th 08 05:57 PM
Help with multiple If statement Mike Busch[_2_] Excel Discussion (Misc queries) 3 November 15th 07 04:33 PM
Help with a multiple OR statement. Pank Excel Discussion (Misc queries) 2 July 11th 06 03:10 PM


All times are GMT +1. The time now is 07:18 AM.

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"