I'm trying to set an adjustment percentage, based on an input value. The adjustment levels are from 100%, 80%, 50%, etc.
in doing this I've been using a nested IF(AND() formula for each range of input values. My problem is the formula entered correctly and works for only the first two ranges, otherwise the cell result is "False". Here is the actual formula:
Range of adjustments:
Cell B2 is a value I enter between 0 and 100+. When B2=100 or greater I get 1 When B2=90-99 I get .8 When B2=Anything else I get False