0

I want to define conditions in cell values and pass them in if statements in google spreadsheets. This is a simple formula how this can be achieved normally

This is simple formula how this can be achieved normally

This is what I am trying to achieve. Instead of formula in 1st parameter in if function, I am setting this condition in one cell value and passing that cell value in if condition parameter.

enter image description here

The reason behind this is, I am having multiple conditions that I need to pass in if statements, so defining in different cells will be more manageable.

Thank You.

0

What you should have in cell would be:

=AND(H31>35,H32>35,H33>35)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.