Hi guys,
I'm looking for a spreadsheet that will tell me what I need to hit target
For instance if I have 100 sweets but sold 75 and my target is 90% it will tell me how many sweets I need to sell to reach target
I would like to be able to alter the target each week
Any ideas
Lets say:
100 (sweets) in A1
75 (sold ) in A2
90% (target) in A3
in A4 (still need to sell) write formula
Formula:
Please Login or Register to view this content.
Best Regards,
Kaper
that gives me the answer of 15 which is 100 %
75+15 = 90, not 100.
Entia non sunt multiplicanda sine necessitate
opps so it does i am having a bad day today lol.
cheers guys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks