|
|
To advertise on these forums, e-mail us. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
Need Excel Help
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. |
#2
|
|||
|
|||
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") |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
Quote:
|
#7
|
|||
|
|||
as crackone replied copying that formula to column E should do the trick
|
Thread Tools | Search this Thread |
Display Modes | |
|
|