sophie2000
New Member
- Joined
- Aug 3, 2005
- Messages
- 8
For some reason, I've got a mental block today. Here's what I want to do:
Cell A1 = 100000
Cell A2 = 200000
Cell a3 = 150000 (this is the variable)
If cell A3 is in the range of A1-A2, then return a formula: (A3-A1) *.01
If cell A3 is greater than cell A2, the return a set number: 1000.
As a BONUS, I'd LIKE it to ALSO return a '0' if Cell A3 is less than 100000.
Just can't seem to get it right. Any help really appreciated!
Thank you !
Wendy
Cell A1 = 100000
Cell A2 = 200000
Cell a3 = 150000 (this is the variable)
If cell A3 is in the range of A1-A2, then return a formula: (A3-A1) *.01
If cell A3 is greater than cell A2, the return a set number: 1000.
As a BONUS, I'd LIKE it to ALSO return a '0' if Cell A3 is less than 100000.
Just can't seem to get it right. Any help really appreciated!
Thank you !
Wendy