Need Excel Help

[Try Try Again]

Hoping someone can explain if it is possible apply the ROUNDUP application to a cell that already has a formula applied to it.
At the moment I have a separate column for the Roundup application.

Thanks in advance.

[Crackone]

Can be done depending on your formula you have in the cell to where to put it

eg. =IF(D5>=2500,SUM(D5*0.2),"Does Not Qualify")

=IF(D5>=2500,ROUNDUP(SUM(D5*0.2),0),"D... Not Qualify")

[Try Try Again]

Hi Crackone,

Thanks for the reply.

Formula in cell is pretty basic e.g. =100/D4, so if D4 = 33 Answer would be 33.33

What would you suggest I enter so I can roundup?

Appreciate you taking the tim to help.

[stugots]

hi tta, happy to help if i can but having trouble with your calcs

d4=33, so 100/33 = 3.030303 repeating


the formula to roundup is -

=ROUNDUP(100/D4,0) = 4

[Try Try Again]

Hi Stugots,

Thanks for replying. I don't seem to be explaining the problem very well.

In column D I have various Horse's Rated figures If I want to see how many units I need to place on that horse to collect $100 I enter into column E1 the formula =100/D1 and copy this down column E to get the units for all horses.

My question is if this formula is already in Column E is it possible to also enter in column E the ROUNDUP formula so all units are whole numbers taken to the next whole number?

Hope this makes the problem clearer.

[Crackone]

hi tta, happy to help if i can but having trouble with your calcs

d4=33, so 100/33 = 3.030303 repeating


the formula to roundup is -

=ROUNDUP(100/D4,0) = 4Try, this is the formula you put in column E and copy it down.

[stugots]

as crackone replied copying that formula to column E should do the trick

[Try Try Again]

Thanks Stugots and Crackone,

That is what I currently do. I was hoping to eliminate a column for the spreadsheet.

[Crackone]

Try, do you want the formula in column D ??

What formula do you can in column D (for your ratings)

[Try Try Again]

Yes Crackone.

Ideally I want to put in the same cell (D1) the formula (=100/B1) and the ROUNDUP application.

Currently, the formula is entered into D1 and the ROUNDUP application is entered into E1.

If I try to enter both applications into D1 I get a loop. Not sure whether I had in fact entered the "correct" string as I am not that much of an aaaaaa on Excel.

Thanks for taking the time to help me.

[Crackone]

put this in column D1 and copy it dowm
You want need column E delete it

=ROUNDUP(100/B1,0)
This will divide your rating into 100 and then round it up to the next hole number.

Cheers

[Try Try Again]

Hi Crackone,

That's exactly what I was after!
Thanks for your patience and help - much appreciated. That's what I like about this website the help that is freely available from all sources - Sensational!

[aussielongboat]

Hi Crackone,

That's exactly what I was after!
Thanks for your patience and help - much appreciated. That's what I like about this website the help that is freely available from all sources - Sensational!

I am a self accredited "gun" at excel so if you want to send me a sample i can see if i can automate more for you.

you know Christmas holidays and the like - a bit bored - so need some new projects.

cheers

Aussie