Hi everyone,
I’ve searched the forum but unable to find an answer so apologies if this has been answered before.
Is it possible to code an IF function where I compare multiple cells in a row to see if any are a certain percentage above one cell, and if so output TRUE?
For example I have cells B to Z with numbers in and if any of those cells are 50% greater than cell A, output equals TRUE.
If this isn’t possible, are there any other ways I could perform a different function to get the same result? I’d like to hard code ideally to copy the function to multiple rows.
Many thanks in advance
I’ve searched the forum but unable to find an answer so apologies if this has been answered before.
Is it possible to code an IF function where I compare multiple cells in a row to see if any are a certain percentage above one cell, and if so output TRUE?
For example I have cells B to Z with numbers in and if any of those cells are 50% greater than cell A, output equals TRUE.
If this isn’t possible, are there any other ways I could perform a different function to get the same result? I’d like to hard code ideally to copy the function to multiple rows.
Many thanks in advance