paulfurlong
New Member
- Joined
- Sep 4, 2008
- Messages
- 5
hi, I hope someone might be able to help me formulate a simple bonus payment spreadsheet!
I am trying to fathom "less than greater than" syntax in a formula without much success...!
In simple terms I am trying to find a formula that says:
In n27 i need a formula "if n26 (total revenue) figure is between 62000 and 105,000 then work out 10% of that figure, if not return 0"
In n28 I need a formula "if n26 is 105,001 and greater then return a value of 30% of that figure, if not return 0"
Any help is much appreaciated!
Thanks in advance
I am trying to fathom "less than greater than" syntax in a formula without much success...!
In simple terms I am trying to find a formula that says:
In n27 i need a formula "if n26 (total revenue) figure is between 62000 and 105,000 then work out 10% of that figure, if not return 0"
In n28 I need a formula "if n26 is 105,001 and greater then return a value of 30% of that figure, if not return 0"
Any help is much appreaciated!
Thanks in advance