I'm really new at all of this and I've been racking my brain for a while on this. To no avail, I am coming up with errors.
Here's what I'm trying to do:
I need to get a cell to read "Flammable" only under these conditions:
“FLAMMABLE” ONLY IF B22 > 1000, but < 8820
AND
“FLAMMABLE” ONLY WHEN B22 is >8820 AND THERE ARE VALUES GREATER THAN 0 in ANY of the following boxes: C22,E22:G22,I22,K22,M22,N22
Any help would be greatly appreciated!
Bookmarks