Thread
:
Urgently need help with a formula!!!
View Single Post
#
2
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
Urgently need help with a formula!!!
You have replies at your other posts.
wrote:
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
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson