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: ...
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.
=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.
