Excel help plz.....

Frankers

Posts: 97

Free Member

Topic starter

Translate ▼

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

CharlieMungus

Posts: 0

Free Member

Translate ▼

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

TheSouthernYeti

Posts: 0

Free Member

Translate ▼

=ROUNDUP(IF(($K$7*318)/A9<$F$1,$K$7*318/A9,$F$1),-2)

Posted : 19/05/2011 11:06 am

thebunk

Posts: 1680

Full Member

Translate ▼

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

Frankers

Posts: 97

Free Member

Topic starter

Translate ▼

10/10 to The Yeti, thanks very much !!!

And to theBunk

Posted : 19/05/2011 11:11 am

[Closed] Excel help plz.....