|
|
#2
09-26-2021, 11:09 PM
|
|||
|
|||
On fly (Based on comma you used as decimals delimiter I used semicolons as formula delimiters. In case I was wrong, replace them with commas!)
Code:
=IF(AND($A2>=9000,7;$A2<=11500,5);"Pass";"Fail") 
|
| Tags |
| excelformula, formula, passfailed |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Pass a range to another macro to bold before em dash
|
jeffreybrown | Word VBA | 2 | 09-12-2018 04:14 PM |
| Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N | mikey386 | Excel | 2 | 12-11-2014 01:14 PM |
|
How to Pass Arguments in a Formula?
|
tinfanide | Excel Programming | 2 | 10-13-2014 06:10 AM |
| Fail-safe way to print right page range? | New Daddy | Word | 5 | 09-22-2013 11:10 PM |
|
Range Formula
|
aleksandr | Excel | 10 | 05-18-2009 12:14 PM |
Windows 8 
Office 2016
Threaded Mode