New User needs help with formulas!

[Excel_Warrior]

Morning people.

As usual I have been told I need to do somehting ASAP so I turn to you all for help.

I have the following two formulas that work seperately:
=IF(Q4="n/a","n/a",(Q4/1000*2)*40)

=CEILING(Q29,10)

How do I put them in one formula?
I know this will be annoying for some people but I can't get them together.

I thought it would work:

=IF(Q4="n/a","n/a",(Q4/1000*2)*40) (CEILING(Q29,10))

But it doesn't...

Any help would be appreciated as I only have 2 hours to do this (got to love management!)

Thanks in Advance

Col

[Portuga]

Not sure what you are trying to do here.
The first cell is an if statement that has arguments for true and false. for cell Q4, the other reffers to a ceiling to another cell...

what is it that you want to do exactly? (more than just put them together)

In which case:

=IF(Q4="n/a","n/a",(Q4/1000*2)*40) & " " & (CEILING(Q29,10))

[Excel_Warrior]

Sorry for the severe lack of information.

I am trying to get informaiton from one cell, if it's n/a then it is to come up n/a, but if it is a figure it needs to be /1000*2)*40 and then rounded up to the nearest 10. (ie: (CEILING(Q29,10))

I have no idea. Both work perfectly seperately but when I put htem together it comes up with a 'circular error thingie' (love my technical lanuage!)

[Portuga]

Try:

=if(Q29="n/a","n/a",ceiling(((Q29/1000*2)*40),10))

[Excel_Warrior]

You are a fantastic human being!!!!!!!!!!!!!!!!!!!!!

Thank yo soooooooooooooooooo much! That worked well...

I guessing it reads that if this do this and if this do the ceiling function on the result of the maths in the second set of parenthesis...

I wish you were in Australia and I'd send you beer!

Thanks again!!!!

Col

[Portuga]

No worries mate.
Take c