Urgently need help with a formula!!!
Hello,
I'm badly in need of some help with an excel formula. Essentially I
need to check to see if the value of C7 is "Y" and if so for the
formula then to look at D7 through to J7 and look for a value of "Yes".
the total amount of "Yes" boxes should then be multiplied by J5 and the
result shown in L7.
It is for the purpose of a timesheet, I'm trying to calculate fuel
allowances The Value C7 "Y" indicates that i drove and the values D7
through to J7 are days of the week Monday to Sunday, For each day i
drove somewhere I enter "Yes" the amount i'm allowed for my fuel
allowance is displayed in J5 so you can see that i need to multiply the
days of the week that i drove by the allowance.
I hope this is explained well enough!
Any help you might be able to give would be greatly appreciated!
Thanks,
Bill
|