Toribash
FAQ
Advanced Search
Subscribed Threads
Today's Posts Mark Forums Read
Reply
Switch to Linear Mode Switch to Hybrid Mode Switch to Threaded Mode
Original Post
View Public Profile Send a private message to HelgeBot Find More Posts by HelgeBot
Active Inventory Deactivated Inventory Trade History

Mar 29, 2009 Old
View Public Profile Send a private message to HelgeBot Find More Posts by HelgeBot
Active Inventory Deactivated Inventory Trade History
Junior Member HelgeBot's Avatar
Join Date: Feb 2009
Mar 29, 2009 Old
[Help]%Off in excel ?
how do i make a function that is if you got something that costs 100 tc and you sell it for 50tc and the % of is 50 .....how do i do that in excel ?
Signature: Here | Obama: Here
Quote
View Public Profile Send a private message to Gamerbad Find More Posts by Gamerbad
Active Inventory Deactivated Inventory Trade History

Mar 29, 2009 Old
View Public Profile Send a private message to Gamerbad Find More Posts by Gamerbad
Active Inventory Deactivated Inventory Trade History
Senior Member Gamerbad's Avatar
Join Date: Mar 2008
Mar 29, 2009 Old
he means

you got the original price in cell 1 and the price he sold it for in cell 2
then in cell 3 he got how many % of the original price he sold it for get it now ?
Helge Sverre - System Developer
https://helgesverre.com
Quote
View Public Profile Send a private message to Hykimachi Find More Posts by Hykimachi
Active Inventory Deactivated Inventory Trade History

Mar 29, 2009 Old
View Public Profile Send a private message to Hykimachi Find More Posts by Hykimachi
Active Inventory Deactivated Inventory Trade History
Senior Member Hykimachi's Avatar
Join Date: Jan 2009
Mar 29, 2009 Old
Ohh i can't remember but i know this but don't remember how . I will try to remember by using excel now.



EDIT : sorry cant remember (and I don't try very hard cuz i am too lazy)
Last edited by Hykimachi; Mar 29, 2009 at 04:15 PM.
Quote
View Public Profile Send a private message to Gamerbad Find More Posts by Gamerbad
Active Inventory Deactivated Inventory Trade History

Mar 29, 2009 Old
View Public Profile Send a private message to Gamerbad Find More Posts by Gamerbad
Active Inventory Deactivated Inventory Trade History
Senior Member Gamerbad's Avatar
Join Date: Mar 2008
Mar 29, 2009 Old
Originally Posted by Hykimachi View Post
Ohh i can't remember but i know this but don't remember how . I will try to remember by using excel now.



EDIT : sorry cant remember (and I don't try very hard cuz i am too lazy)

hmm *screams* ANY MATH GEEK IN HERE ?
Helge Sverre - System Developer
https://helgesverre.com
Quote
View Public Profile Send a private message to Chartle Find More Posts by Chartle
Active Inventory Deactivated Inventory Trade History

Mar 29, 2009 Old
View Public Profile Send a private message to Chartle Find More Posts by Chartle
Active Inventory Deactivated Inventory Trade History
I like pink fluffy elephants Chartle's Avatar
Join Date: Sep 2007
Mar 29, 2009 Old
Eh, [your number]/100 times the percent you want.
example: You need 45 percent out of 400 tc: 400/100 = 4 times 45 percent = 180 ;)
[o]|ORMO|Replay thread!
Last edited by Chartle; Tomorrow at 13:37 AM..
Quote
View Public Profile Send a private message to Gamerbad Find More Posts by Gamerbad
Active Inventory Deactivated Inventory Trade History

Mar 29, 2009 Old
View Public Profile Send a private message to Gamerbad Find More Posts by Gamerbad
Active Inventory Deactivated Inventory Trade History
Senior Member Gamerbad's Avatar
Join Date: Mar 2008
Mar 29, 2009 Old
Originally Posted by iPingu View Post
Eh, [your number]/100 times the percent you want.
example: You need 45 percent out of 400 tc: 400/100 = 4 times 45 percent = 180 ;)

.....
Helge Sverre - System Developer
https://helgesverre.com
Quote
View Public Profile Send a private message to Chartle Find More Posts by Chartle
Active Inventory Deactivated Inventory Trade History

Mar 29, 2009 Old
View Public Profile Send a private message to Chartle Find More Posts by Chartle
Active Inventory Deactivated Inventory Trade History
I like pink fluffy elephants Chartle's Avatar
Join Date: Sep 2007
Mar 29, 2009 Old
..

Okay, you want 30 percent of cell A1 which is 170.
In cell B1 you type "A1/100*30" without the "s.
[o]|ORMO|Replay thread!
Last edited by Chartle; Tomorrow at 13:37 AM..
Quote
View Public Profile Send a private message to Hykimachi Find More Posts by Hykimachi
Active Inventory Deactivated Inventory Trade History

Mar 29, 2009 Old
View Public Profile Send a private message to Hykimachi Find More Posts by Hykimachi
Active Inventory Deactivated Inventory Trade History
Senior Member Hykimachi's Avatar
Join Date: Jan 2009
Mar 29, 2009 Old
Originally Posted by iPingu View Post
Eh, [your number]/100 times the percent you want.
example: You need 45 percent out of 400 tc: 400/100 = 4 times 45 percent = 180 ;)


Ohh iPingu thanks for helping that guy .If i was not so lazy i maybe helped him too.
Quote
Reply

« Previous Thread | Next Thread »