help with formula

Copper 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
You have put your number in Cell "A1".
Remember you didn't define any value for negative number.


Thank you, thank you!

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