harryfishy
New Member
- Joined
- Feb 19, 2018
- Messages
- 2
Sorry folks, not the greatest thread title I know but I thought best to put all three questions in one post.
1) I currently have a field (R17) that is automatically 10% of R15. However I want this figure to go no higher than 200. (Eg - R15 is 10,000, R17 is 200 rather than 100).
2) I also want this field to go up in multiples five (but obviously never above 200).
3) My various calculations are all added up to give a "total" in a field (R18). I would like to create three macro's (or buttons as I call them!) One button whereby pushing it uplifts this figure by 5%, one that does it by 10% and one that does it by 15%. (Eg - R18 is £5,000, pushing 5% button changes R18 to £5,250).
Thank you!
1) I currently have a field (R17) that is automatically 10% of R15. However I want this figure to go no higher than 200. (Eg - R15 is 10,000, R17 is 200 rather than 100).
2) I also want this field to go up in multiples five (but obviously never above 200).
3) My various calculations are all added up to give a "total" in a field (R18). I would like to create three macro's (or buttons as I call them!) One button whereby pushing it uplifts this figure by 5%, one that does it by 10% and one that does it by 15%. (Eg - R18 is £5,000, pushing 5% button changes R18 to £5,250).
Thank you!