Snasui Excel Forum

Hi dear

I need some help to control under cap expense
I have some limited expense caps as following
-Expense with potential client per month like breakfast,lunch or dinner with potential client only cap 100$
-Expense for football tournament per month
include rent football court, drinking water and referee only cap 100$
-Expense for company vehicle fuel(diesel) only cap 150$.
I need formula to show status for each expense
"Under cap" or "beyond cap" or if equal it shows "within cap" .
and in adjacent column the amount left after every expense.


Best wishes,

Last update file with different currency

Here's attached

Note an exchange rate 1 USD equals to 4,000 KHR

Try this,

1. E5 Fill in with the text 'Convert'
2. E6
   =D6/IF(C6="KHR",4000,1)
   Press enter and copy down.
3. D2
   =MIN(C2,SUMIF($B$6:$B$12,"*"&B2&"*",$E$6:$E$12))
   Press enter and copy down to D4.
4. E2
   =C2-D2
   Press enter and copy down to E4.

Hi Dear
Thanks it works flawlessly