Forum Discussion

GCWESTWOOD's avatar
GCWESTWOOD
Copper Contributor
Feb 05, 2020
Solved

formula help

Hi,   I'm looking to create a formula where the sum depends on the number entered in the first cell, for example the 1st variable can be 1-2, 2nd is 3-4 and 3rd is 5+.    If the first variable is...
excel
Formulas and Functions
  • Savia's avatar
    Savia
    Feb 05, 2020
    Try:

    =B2*IF(A2<=2, 5, IF(A2<=4, 7.5, 10))
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 05, 2020

GCWESTWOOD 

As variant

=5+2.5*(CEILING(MIN(5,A2),2)/2-1)
  • GCWESTWOOD's avatar
    GCWESTWOOD
    Copper Contributor
    Feb 05, 2020
    thanks @sergei bakan but this didn't work for me.
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Feb 05, 2020

      GCWESTWOOD 

      IMHO, it works. At the right - adjusted to zero formula

Resources