Thread: Formula Pass/Fail for a range value
View Single Post
 
Old 09-26-2021, 10:48 PM
Ruiy Ruiy is offline Windows 7 64bit Office 2007
Novice
  
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