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: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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: 345
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 02:17 AM.


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