If you want the result in a new cell, then you would just use the following formula for example: =D1*160

That would multiply the number in the D1 cell by 160.

Solved

Posted on 2012-08-24

Me again!

I am working on a spreadsheet and need some help with some simple formulas. How simple? It's almost embarrassing for me to ask.

As I build this simple spreadsheet I will be asking some questions here.

The first one is the following

"Row D has a number. I want the formula to multiply that number by 160 (just regular 160, no percentage.) and then put the result of that multiplication in Row D".

That's the start! I expect I will have about 4 of these formulas that I will need to complete this spread sheet.

Rowby

I am working on a spreadsheet and need some help with some simple formulas. How simple? It's almost embarrassing for me to ask.

As I build this simple spreadsheet I will be asking some questions here.

The first one is the following

"Row D has a number. I want the formula to multiply that number by 160 (just regular 160, no percentage.) and then put the result of that multiplication in Row D".

That's the start! I expect I will have about 4 of these formulas that I will need to complete this spread sheet.

Rowby

9 Comments

If you want the result in a new cell, then you would just use the following formula for example: =D1*160

That would multiply the number in the D1 cell by 160.

=D2*160

If you have more numbers down column D then you can drag that formula down as far as you want

regards, barry

Got it for the first part. Here is I think the only other formula I need.

1) Do this calculation: Column B x .00247 then get 85% of the result of that sum. Hold that final result.

2) Then do this calculation: Column B x .000457. Hold that final result.

Add the result of 1 and 2 and put the grand total in Column A.

I hope that makes sense!

Note: I will be appropriately splitting the points

=B2*0.00247*85%+B2*0.00045

If B2 is 1000 that will give the result 2.5565 in A2 is that right?

regards, barry

Your formula:

=B2*0.00247*85%+B2*0.00045

is working fine!

One final refinement. The grand total should be rounded off to the higher number (eliminating any resulting percentages.)

Example If the final calculation is 2.5565 -- round it off to 3

Thanks

Rowby

=ROUNDUP(B2*0.00247*85%+B2

or even CEILING if your number will always be positive, i.e.

=CEILING(B2*0.00247*85%+B2

regards, barry

By clicking you are agreeing to Experts Exchange's Terms of Use.

Title | # Comments | Views | Activity |
---|---|---|---|

Best, Average or Worst ? | 12 | 54 | |

trailing spaces all columns | 4 | 42 | |

Excel 2010 Sparklines - horizontal bar | 2 | 22 | |

How to customise Office 2016 font settings with a GPO | 3 | 20 |

Join the community of 500,000 technology professionals and ask your questions.

Connect with top rated Experts

**18** Experts available now in Live!