Forum Discussion

Glen_Pierce's avatar
Glen_Pierce
Copper Contributor
Jan 07, 2023

help with formula

I am trying to construct a single formula to calculate a payroll rate and am relatively inexperienced. Though the conditions are a bit more complicated than this, they are essentially the following: 

if a=0, then b=0

if a>0 and a<1.01, then b=50

if a>1, then b=100 

The calculated value for the cell needs to be a number rather than "true" or "false"

 

Any help is appreciated. Thanks

 

 

Formulas and Functions
  • Peyman_gholami's avatar
    Peyman_gholami
    Copper Contributor
    Jan 07, 2023
    Hi,
    =If(A1=0,0,if(A1>1,100,50))
    You have put your number in Cell "A1".
    Remember you didn't define any value for negative number.
    • Glen_Pierce's avatar
      Glen_Pierce
      Copper Contributor
      Jan 07, 2023

      Peyman_gholami 

      Thank you, thank you!

      I've been laboring with the idea of multiple if(and combinations and completely overlooked the simplest solution.

Share

Resources