This is a manual expence form that i need to automate.
I'm relatively new to excel and cant seem to grasp the format used when doing multiple criteria, i also want to keep the form as neat as possible and don't want 00.00 in the formula box if there is no value, although i could use conditional formatting, if needed, any help and advice gratefully received.
In columns E and F shows cash receipted
In columns G and H shows cash no receipt
In columns I and J shows credit card purchases
I need to calculate each section relavent to the curency being used at the time (we travel all over the world so i need to match what is in C29 to C33 rather than give actual symbols)
So all £, $, €, K, B would need to be calculated individually and put in there relavent row in K29 to K33, then the diference between Used K29 to K33 and Available would be in, Remaining L29 to L33.
The main thing is i need whatever symbol/letter i put in C29 to C33 to be variable due to contries traveled
Expence Form.xlsx
Bookmarks