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))
GCWESTWOOD's avatar
GCWESTWOOD
Copper Contributor
Feb 05, 2020

Savia  is it possible to add in a step that if A2 = 0 then equals 0??

Savia's avatar
Savia
Iron Contributor
Feb 05, 2020
Sure:

=B2*IF(A2=0, 0, IF(A2<=2, 5, IF(A2<=4, 7.5, 10)))

Resources