Hi everyone,
I am working on creating an expense report. I would like to set up a formula that checks to see if a specific word or phrase is in one column and if so then it will display the amount in the correct column.
In columns H and I, I would like for it to check column G for the payment method. If the payment type is Cash or Personal Credit Card I would like it to display the $ Amount from the same row in Column D in Column I (Expense reimburse total). If the payment type is Company Credit Card I would like it to display the $ Amount from the same row in Column D in Column H (Company CC total).
The worksheet is attached.
Thank you in advance,
Nikki
Bookmarks