hello, I have a quick question and looking for a quick answer
I have cell C5=300 and cell C6=400, how do I get it to write it out for me in cell C7=C6/C5 which is 400/300?
hello, I have a quick question and looking for a quick answer
I have cell C5=300 and cell C6=400, how do I get it to write it out for me in cell C7=C6/C5 which is 400/300?
didn't you just answer your question??
=C6/C5
no.. try inserting that into excel, it will give you 1.3 not 400/300
I'm required to show work and not give a direct answer. therefore I don't want it to solve the equation, I want it to write it out... get it?
Try:
=C6&"/"&C5
ok thanks, but a new problem occurred.. It's giving me a number like 0.03109738243420943/0.01284791823 How do I reduce the decimal places?
Are 0.03109738243420943 and 0.01284791823 the two values in C6 and C5? If not, are the values in C6 and C5 rounded, but the real values underneath them are what you show above?
Perhaps try:
=TEXT(C6,"0.00")&"/"&TEXT(C5,"0.00")
This will convert any number to two decimal places only.
A new can of worms..
maybe=C6&"/"&C5
=round(c6,2)&"/"&round(C5,2)
sweet, you guys rule.. I've always wondered how this could be done without doing it myself, never taught us this in school. Great time saver.
Yeah, those darn teachers always trying to get you to figure out how to do things on your own. Horrible!
Glad you got it sorted out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks