Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

# Request for help for some simple Excel Formulas

Posted on 2012-08-24
Medium Priority
329 Views
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
0
Question by:Rowby Goren
• 5
• 3

LVL 12

Expert Comment

ID: 38331307
"D" would actually be a column and not a row.  So you want the result to replace the original number in column "D"?

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.
0

LVL 50

Expert Comment

ID: 38331320
Lets say you have a number in D2, you can use this formula in E2 to multiply 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
0

LVL 9

Author Comment

ID: 38331396
Thanks, Seaton007 and 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
0

LVL 50

Expert Comment

ID: 38331469
Assuming B2 try this formula in A2

=B2*0.00247*85%+B2*0.000457

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

regards, barry
0

LVL 9

Author Comment

ID: 38331523
Hi Barry

=B2*0.00247*85%+B2*0.000457

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
0

LVL 9

Author Comment

ID: 38331530
will "=ROUNDUP" do it?
0

LVL 50

Accepted Solution

barry houdini earned 2000 total points
ID: 38331572
Yes you can use ROUNDUP like

=ROUNDUP(B2*0.00247*85%+B2*0.000457,0)

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

=CEILING(B2*0.00247*85%+B2*0.000457,1)

regards, barry
0

LVL 9

Author Comment

ID: 38331581
Thanks barryhoudini

Sounds  good.

Can you tell me more what you mean by using ceiling "if your number will always be positive
"

The end result will always be a whole number and no percentages.

For example  \$100.99 would not be used.  It would be \$100 always  (no cents)

Thanks

Rowby
0

LVL 9

Author Closing Comment

ID: 38338801
Thanks barry,

Formula is working fine.  If you cop" tmment on this, give me some thoughts on comparing "Roundup" to "Ceiling".  Or post  a "good link" that compares the two.

Rowby
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a â€¦
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
###### Suggested Courses
Course of the Month11 days, 18 hours left to enroll