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: 201
Default conditional formula

i am trying to find/create a formula with the following information but have
seem to hit a wall i will try to explain

if b1 is greater than or equal to 20 than b2 is 25 or
b1 is greater than or equal to 15 but less than 20 b2 is 20 or
b1 is greater than or equal to 10 but less than 15 b2 is 15 or
b1 is greater than or equal to 2 but less than 10 b2 is 10 or
b1 is greater than or equal to 1 but less than 2 b2 is 5 or
b1 is less than 1 than b2 is 0

thanks for any ifo available
 
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
Conditional Formula Lisa Excel Discussion (Misc queries) 4 June 5th 08 01:20 PM
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible blue[_2_] Excel Discussion (Misc queries) 2 July 11th 07 06:08 PM
Formula, Conditional Formula Needed Karl Excel Discussion (Misc queries) 12 June 23rd 07 04:12 AM
Conditional formula Michelle Excel Worksheet Functions 7 May 25th 07 08:07 PM
Conditional Formula to indicate Formula in cell SteveW New Users to Excel 9 August 2nd 06 01:12 AM


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