I am trying to write a fomula which will look at the current conversion rate for samples sent to replies received, take the target for replies received for next year and use it to work out how many samples need to be sent to gain the required number of replies.
The attached spreadsheet shows the manually-calculated results in red, but I want to automate this sum.
My brain will not work out the maths I need to do - can someone help?
Thanks G
=100%/D3*F3
and copy down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
In G2 and coipied down...
=F3/D3
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks both - both work!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks