LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
DWD DWD is offline
external usenet poster
 
Posts: 4
Default Not just True/False

I'm would like to have a cell display Pass, Conditional, or Fail depending on
a score in another cell. For example, if the score is below 60, display
Fail, between 60 and 70 display Provisional, 70, display Pass. I can get
pass/fail, but not the three responses.

Help???

Thanks
--
Dan Davenport
 
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
Check box - true/false - i'd like a third option n/a Kelly 1st Excel Discussion (Misc queries) 6 February 24th 10 01:23 PM
Return True/False to check duplicate items in a range with one for Tetsuya Oguma Excel Worksheet Functions 10 October 21st 06 03:20 AM
Boolean 0/1 instead of True/False Tony Excel Discussion (Misc queries) 10 May 29th 06 04:14 AM
Look up to return a true/false value WTG Excel Worksheet Functions 1 April 12th 06 04:14 PM
Want to change the color of a true/false logical statement with i. gregspainting Excel Worksheet Functions 2 February 19th 05 06:42 PM


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