ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Apply formuls to whole row (multiply ColumnC*.00274)? (https://www.excelbanter.com/excel-worksheet-functions/5724-apply-formuls-whole-row-multiply-columnc%2A-00274-a.html)

Heather

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!

RagDyer

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!



All times are GMT +1. The time now is 05:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com