if formula

BONNIE WILLIAMSON

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

jrobbins

=If([receipt amount cell] > [allowance amount cell], [allowance amount cell], if([receipt amount cell] < [allowance amount cell], [receipt amount cell], ""))

Hopefully that makes sense

BONNIE WILLIAMSON

Thank you very much!!

ddietz

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