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
![Excel formula error "Value"]()
If I use formula
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")
If I use formula
=IF(EXACT([@[Boomcode check_DSLR_S]],"Good"),"Ready","Not Ready")
Microsoft ExcelMicrosoft Office
Last Comment
Gilberto Sanches
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
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Ahahaha, oh my goodness, so simple. I only needed to press CTRL-SHIFT-ENTER rather than just ENTER.
It works! Thanks experts
It works! Thanks experts
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