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

Urgently need help with a formula!!!
 

You have a response in .Functions. Please don't multi-post.

Pete

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

Urgently need help with a formula!!!
 

see your other post.


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



" escreveu:

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