Link to home
Start Free TrialLog in
Avatar of Gilberto Sanches
Gilberto SanchesFlag for Suriname

asked on

Excel show "Ready" if multiple cells have value "Good"

Hi experts,

What is the formula in Excel to show "Ready" if multiple cells, see screenshot, have value "Good" ?
I tried formula
=IF(AND(EXACT(Export___Daily_Sheet_Scaling_2_Screening[@[Boomcode check_DSLR_S]:
[Species check_DSI_F]],"Good")),"Ready","Not Ready")

Open in new window

but it gives error "Value"
User generated image
If I use formula
=IF(EXACT([@[Boomcode check_DSLR_S]],"Good"),"Ready","Not Ready")

Open in new window

it works, but that only checks 1 cell.
Avatar of Bill Prew
Bill Prew

The AND() needs to contain a list of multiple individual cell comparisons, not a range.

If you have a lot of cells n the range then it might be easier to do a COUNTIF() with a "<>" to the value "Good" and if the count is greater than 0 then assign "Not Ready" else "Ready".


»bp
This may help..

https://www.extendoffice.com/documents/excel/2537-excel-compare-if-multiple-cells-are-equal.html

Shows that the exact function can be done over a range
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Gilberto Sanches

ASKER

Ahahaha, oh my goodness, so simple. I only needed to press CTRL-SHIFT-ENTER rather than just ENTER.
It works! Thanks experts