4petessake
New Member
- Joined
- Nov 17, 2005
- Messages
- 17
Hi everyone, I am working on a spreadsheet and have three columns in my lookup table
ROA 1 ROA2 Percentage
2.00 2.50 115%
etc etc etc
How do I write a formula to say if roa1 is between 2.00 and 2.50, then percentage equal 115%?
TIA
ROA 1 ROA2 Percentage
2.00 2.50 115%
etc etc etc
How do I write a formula to say if roa1 is between 2.00 and 2.50, then percentage equal 115%?
TIA