I'm not sure how exactly to explain this so I have attached a sample worksheet so you can see what I'm talking about.
"I just need to know how to get the variable percentage of C2 - C5 to show up in E2 - E5. So, basically I want E2 to show "48" because that is 80% of 60 but I want to be able to change the precentage in D2 and have E2 adjust based on whatever percentage is entered."
So, if the employee is allowed 60 miles, but only got 80% of those miles, I want the third cell to reflect 80% of 60. But, the percentage is going to change and will not always be even amounts (they usually are more like 75.43% or something) and I would need the third cell to reflect the accurate number based on what the percentage is.
I hope I'm making at least a little bit of sense.
Any help is appreciated.
Thank you in advance!
Last edited by GeekyGirl; 10-05-2011 at 04:59 PM.
Fill that formula down from E2:E5.=C2*D2
If your question has been satisfactorily addressed, please consider marking it solved. Click here to see how.
Also, you might want to add to the user's reputation by clicking the scales icon - it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
Oh wow. Sometimes I amaze myself with how complicated I work things up in my head. Hahahaha, thank you so much. >.<
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks