|
|
#1
09-26-2021, 10:48 PM
|
|||
|
|||
Formula Pass/Fail for a range value
Hi guys,
I'm a newbie here. This is my first thread and I need help for my excel problem. I have various data in cells (A2-A100), say from 8.000 until 12.000 and I want using formula that says the data is Pass if the data is "9.000,70-11.500,50" meanwhile the others are Failed. I've used any possible formula but still can't find the works one. 
|
|
#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 |
|
|
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 7 64bit 
Office 2007
Linear Mode
