The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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

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

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

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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

=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