Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Heather
 
Posts: n/a
Default Apply formuls to whole row (multiply ColumnC*.00274)?

I want to know how to create a general formula for a row to help with simple
but timely calculations. I need to enter a date and find have the formula
return a date 60 days from that date. Also I need to enter an amount and find
what 10% of that amount is. I want to be able to enter a bunch of dollar
values in a column then in the next column see what 10% of that value is.
This could save me hours and hours of tedious calculations. Thank You!
  #2   Report Post  
RagDyer
 
Posts: n/a
Default

If you have a true XL date (not a text entry) in A1, simply enter this
formula in B1:

=A1+60

If you have a number in A2, and you need to display 10% of that number,
enter this formula in B2:

=A2*0.1
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================





"Heather" wrote in message
...
I want to know how to create a general formula for a row to help with simple
but timely calculations. I need to enter a date and find have the formula
return a date 60 days from that date. Also I need to enter an amount and
find
what 10% of that amount is. I want to be able to enter a bunch of dollar
values in a column then in the next column see what 10% of that value is.
This could save me hours and hours of tedious calculations. Thank You!

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Chart: cannot apply the default chart type... doco Charts and Charting in Excel 1 January 17th 05 04:55 PM
How do I apply a combo box to multiple cells in Excel so that it . DB Excel Discussion (Misc queries) 1 January 12th 05 03:42 PM
How do I apply a Function to a column of cells and change there va Froggy New Users to Excel 1 December 23rd 04 12:09 AM
Can Excel be pre-formatted to apply "double quotes" to data enter. RV Excel Worksheet Functions 0 November 4th 04 06:09 PM
making a column of formuls constant Jake Excel Worksheet Functions 2 November 2nd 04 01:45 AM


All times are GMT +1. The time now is 10:42 PM.

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

About Us

"It's about Microsoft Excel"