Coding a comparison of multiple cells to one

[Av8]

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

 

[etaf]

i would think perhaps using a MAX() across B to Z
=MAX(B2:Z2)
then test that MAX to see if above 50% greater than A
the value in A2 to test - If reading correctly - 50% higher than A would be A2*1.5
So
Max(B2:Z2)>A2*1.5
AND copy down - will show each row

If i have read the requirement correctly
OR is this the whole range ? compared

 

[Av8]

Thanks for your quick reply etaf. Your suggestion looks like a great solution. I’ll test it and report back.

 

[Av8]

Thanks for your quick reply etaf. Your suggestion looks like a great solution. I’ll test it and report back.

Thanks etaf, worked a treat

 

[etaf]

you are welcome