Topic starter
How to combine the following formulas
=IF(($K$7*318)/A9<$F$1,$K$7*318/A9,$F$1)
=ROUNDUP(I9,-2)
At the moment i have them in 2 seperate cells and want to combine them in 1
Many thanks 🙂
Posted : 19/05/2011 10:40 am
not sure what you want to do, you mean roundup the first equation? if so, just stick all that in as the first term of the roundup eqn.
Posted : 19/05/2011 11:04 am
=ROUNDUP(IF(($K$7*318)/A9<$F$1,$K$7*318/A9,$F$1),-2)
Posted : 19/05/2011 11:06 am
if I9 contains your first formula, try putting the following in I9 instead.
=ROUNDUP(IF(($K$7*318)/A9<$F$1,$K$7*318/A9,$F$1),-2)
I'm guessing though...
[EDIT - typical!]
Posted : 19/05/2011 11:08 am
Topic starter
10/10 to The Yeti, thanks very much !!!
And to theBunk
Posted : 19/05/2011 11:11 am