Excel extended OR formula
Posted on 2011-10-03
New to Excel formulas, and I can't seem to find a definitive answer over Google so here I am.
I am using:
=IF(OR(Table_Conversion_data[[#This Row],[Interface %]]) >=25%, 4,0)
the cell value is in another worksheet if you are wondering why the complicated value there and is linked. This formula works fine.
However I want to extend it to be something like (i've simplified for the example):
(OR(A1) >=25%, 4(OR(A1) >=50%, 6) f
or example...but I can see it doesn't quite work like this. So basically if the value is >=25%, put the value 4 in, or if >=50% put the value 6 in.