Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-26-2021, 10:48 PM
Ruiy Ruiy is offline Formula Pass/Fail for a range value Windows 7 64bit Formula Pass/Fail for a range value Office 2007
Novice
Formula Pass/Fail for a range value
 
Join Date: Sep 2021
Posts: 1
Ruiy is on a distinguished road
Post 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.
Reply With Quote
  #2  
Old 09-26-2021, 11:09 PM
ArviLaanemets ArviLaanemets is offline Formula Pass/Fail for a range value Windows 8 Formula Pass/Fail for a range value Office 2016
Expert
 
Join Date: May 2017
Posts: 640
ArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of light
Default

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")
Reply With Quote
  #3  
Old 09-27-2021, 05:57 AM
Purfleet Purfleet is offline Formula Pass/Fail for a range value Windows 10 Formula Pass/Fail for a range value Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 335
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Please add a workbook example
Reply With Quote
Reply

Tags
excelformula, formula, passfailed

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Pass/Fail for a range value 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
Formula Pass/Fail for a range value 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
Formula Pass/Fail for a range value Range Formula aleksandr Excel 10 05-18-2009 12:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft