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: 102
Default Need Help with Excel and Flagging Outcomes!

Im using Excel 2007, and here is my question€¦

I want to put a formula in cell C3 that looks at outcomes in cell B3. If the
raw score outcome in cell B3 has the following values, I would like cell C3
to provide the following words:

IF: THEN:

B3=Blank C3=Blank
B3= Greater than 0-1.9 C3=Definitely False
B3=2.0-2.9 C3=Mostly False
B3=3.0-3.9 C3=Dont Know
B3=4.0-4.9 C3=Mostly True
B3= 5.0 or greater C3=Definitely True

Thank you for your help!
 
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
Flagging Up Stock On Excel 2000 Tom1988 Excel Discussion (Misc queries) 2 February 10th 09 01:08 PM
Flagging with Excel Niall 84 Excel Discussion (Misc queries) 2 May 19th 08 11:38 AM
Flagging data in Excel Rob Excel Discussion (Misc queries) 1 February 21st 08 06:02 PM
Spell check flagging words I can't find in Excel LHearn Excel Discussion (Misc queries) 3 December 31st 07 06:09 PM
256 possible outcomes MarkN Excel Discussion (Misc queries) 9 June 28th 06 08:33 AM


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