Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgently need help with a formula!!!
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgently need help with a formula!!!
In L7:
=if(C7="Y",countif(D7:J7,"Yes")*J5,"") -- Regards, Tom Ogilvy " 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need ur help urgently | Excel Worksheet Functions | |||
Urgently need help with a formula!!! | Excel Worksheet Functions | |||
Urgently need help with a formula!!! | Excel Discussion (Misc queries) | |||
Need your help urgently | Excel Worksheet Functions | |||
I need help urgently | Excel Programming |