A
afdmello
Can I enter multiple truths in the logical field.
For eg:
If A3 is equal to G1 or G2 or G3 ( if true) then A1 equal to H1, if false
I want to use the "if " function again to loop as A3 is equal to G4 or G5 or
G6 (if true) then A1 is equal to H2, if false then blank.
I want this type of logic to extend from A1 to A5( so that if the cell A3
changes from G1 to G6 ( or function) then A1 to A5 changes to H1 to H4( or
function) automatically).
Afd
For eg:
If A3 is equal to G1 or G2 or G3 ( if true) then A1 equal to H1, if false
I want to use the "if " function again to loop as A3 is equal to G4 or G5 or
G6 (if true) then A1 is equal to H2, if false then blank.
I want this type of logic to extend from A1 to A5( so that if the cell A3
changes from G1 to G6 ( or function) then A1 to A5 changes to H1 to H4( or
function) automatically).
Afd