Forum Discussion
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
- 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.Thank you, thank you!
I've been laboring with the idea of multiple if(and combinations and completely overlooked the simplest solution.
