if formula
Hi,
I'm in need of a little help. I am trying to create a spreadsheet that allows me to calculate the reimbursement amount. For instance, if the employee returns a receipt over the allowance amount then the total would be the allowance amount. If it's less than the allowance amount then it equals the receipt amount. It seems like it should be easy but it's Monday. Could someone please assist me?
Thank you in advance
B
Comments
-
=If([receipt amount cell] > [allowance amount cell], [allowance amount cell], if([receipt amount cell] < [allowance amount cell], [receipt amount cell], ""))
Hopefully that makes sense
-
Thank you very much!!
-
You will have an issue with this if the receipt is exactly the amount of the allowance. It would be better to simplify the formula and use:
=IF([receipt amount cell] > [allowance amount cell], [allowance amount cell], [receipt amount cell])
Hope this helps!
ddietz
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives