New Contributor

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

2 Replies

Re: help with formula

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.

Re: help with formula

Thank you, thank you!

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