#1
|
|||
|
|||
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
|
|||
|
|||
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") |
#3
|
|||
|
|||
Please add a workbook example
|
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 |