help with formula

New Contributor

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

 

 

2 Replies
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.

@Peyman_gholami 

Thank you, thank you!

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