|
|
#1
10-08-2015, 10:24 AM
|
|||
|
|||
IF command in MS Excel 2010
Hi
I am trying to use the IF command to return a result of "Pass" for a cell giving a numeric value in the range 13 to 99 and "FAIL" outside these values. I seem to be failing miserably! Can anyone help please as I have no hair left to pull out. 
|
|
#2
10-08-2015, 11:30 AM
|
||||
|
||||
|
Perhaps =IF(and(A1>13,a1<99),"pass","fail") if your cell is A1
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#3
10-08-2015, 11:54 AM
|
|||
|
|||
|
Thank you worked perfectly, I wish I had joined the forum earlier. Thank you for such a rapid response also.There are lots of other questions around this theme, like can I change the colour of the cell say Red for Fail and Green for pass. Should I post this question in a new thread? I am new to forums as well as Excel.
|
|
#4
10-08-2015, 11:58 PM
|
||||
|
||||
|
Yes it is better to start a new thread for each question. With a suitable title it will get you help fatser
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can't update/refresh embedded Excel file with Power Point 2010 command button | mt1013 | PowerPoint | 0 | 06-17-2015 05:18 AM |
 Trying to import a calender into a custom calendar from Excel 2010 into Outlook 2010
|
stevecraig2014 | Outlook | 4 | 09-22-2014 07:31 AM |
| Pasting tables from Excel 2010 into Word 2010 - How to fix column widths? | GracieB | Word | 7 | 10-02-2013 06:24 AM |
|
Command line syntax for 2010
|
asearle | Word | 1 | 08-07-2012 05:42 AM |
| Add-In:How to add command right click command bar | phang | Outlook | 0 | 01-15-2007 02:53 AM |
Windows 7 64bit 
Office 2010 64bit
Linear Mode
