Explanation

The value in G5 is hard-coded.

More than one condition can be tested by nesting IF functions.

AND returns TRUEonly if all the conditions are met.

Excel IF function

If any conditions are not met, the AND function returns FALSE.

For example, if A1 contains “apple”, ISBLANK(A1) returns FALSE.

Excel AND function

Excel ISBLANK function