#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default H E L P -Excel

Hello
I am trying to figure out the math on thousands of items. Want to divide
the cost by .56, cant find this!! which function key to do I use??
ty
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,624
Default H E L P -Excel

There's no "function key" to divide cell values by .56.

One possibility.

Enter 0.56 in an empty cell. Copy the cell. Select your thousands of
items. Choose Edit/Paste Special, selecting the Values and Divide radio
buttons. Click OK.



In article ,
Ticklelish wrote:

Hello
I am trying to figure out the math on thousands of items. Want to divide
the cost by .56, cant find this!! which function key to do I use??
ty

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 355
Default H E L P -Excel

try entering .56 in a blank cell. Right click and then copy. Highlight the
thousands of cells and right clickpaste special select values and divide and
then ok. All of the cells will be divided by .56
Hope this helps

"Ticklelish" wrote:

Hello
I am trying to figure out the math on thousands of items. Want to divide
the cost by .56, cant find this!! which function key to do I use??
ty

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"