I would like to combine a function with a formula, can it be done in the same
cell?

David

A formula is a single or a collection of Functions so they are the same
thing, can you be a little more specific what you are trying to do? Do you
mean a macro for example?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"david_b2" wrote in message
...
I would like to combine a function with a formula, can it be done in the
same
cell?

Let's say that in cell A2 you have Gross Pay and in cells A3 through A7 you
have deductions and in cell A8 you have Net pay. the formula in A8 could be
=A2-Sum(A3:A7), If this is not the kind of thing you mean, you have to be
more specific.

"david_b2" wrote:

I would like to combine a function with a formula, can it be done in the same
cell?

if for example you have a formula like =if(A110,"yes","no"), but you want
the formual to state "yes" only if A1 is greater than 10 AND is equal to
another cell, say B4 for example you can add this function to the formula
like this;
=if(and(A110,A1=B4),"yes","no")

i.e. you can have various functions within a formula, you just need to add
them in at the appropriate point.

"david_b2" wrote:

I would like to combine a function with a formula, can it be done in the same
cell?

I would like to add the "Round" function to a formula like, "=G4*(0.076/12)"

"Nick Hodge" wrote:

David

A formula is a single or a collection of Functions so they are the same
thing, can you be a little more specific what you are trying to do? Do you
mean a macro for example?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"david_b2" wrote in message
...
I would like to combine a function with a formula, can it be done in the
same
cell?

I would like to add the "Round" function to a formula like, "=G4*(0.076/12)"

"Loris" wrote:

Let's say that in cell A2 you have Gross Pay and in cells A3 through A7 you
have deductions and in cell A8 you have Net pay. the formula in A8 could be
=A2-Sum(A3:A7), If this is not the kind of thing you mean, you have to be
more specific.

"david_b2" wrote:

I would like to combine a function with a formula, can it be done in the same
cell?

I would like to add the "Round" function to a formula like, "=G4*(0.076/12)"

"hot dogs" wrote:

if for example you have a formula like =if(A110,"yes","no"), but you want
the formual to state "yes" only if A1 is greater than 10 AND is equal to
another cell, say B4 for example you can add this function to the formula
like this;
=if(and(A110,A1=B4),"yes","no")

i.e. you can have various functions within a formula, you just need to add
them in at the appropriate point.

"david_b2" wrote:

I would like to combine a function with a formula, can it be done in the same
cell?

"david_b2" wrote in message
...
I would like to add the "Round" function to a formula like,
"=G4*(0.076/12)"

Yes, you can do that.

=ROUND(G4*(0.076/12),2), for example.

Or, if you're not trying to apply the ROUND to the result but to one of the
intermediate terms, you can use =G4*ROUND(0.076/12,6), for example.
--
David Biddulph

Thanx that was exactly what I was looking for!

"David Biddulph" wrote:

"david_b2" wrote in message
...
I would like to add the "Round" function to a formula like,
"=G4*(0.076/12)"

Yes, you can do that.

=ROUND(G4*(0.076/12),2), for example.

Or, if you're not trying to apply the ROUND to the result but to one of the
intermediate terms, you can use =G4*ROUND(0.076/12,6), for example.
--
David Biddulph

Thanx that was exactly what I was looking for.

"David Biddulph" wrote:

"david_b2" wrote in message
...
I would like to add the "Round" function to a formula like,
"=G4*(0.076/12)"

Yes, you can do that.

=ROUND(G4*(0.076/12),2), for example.

Or, if you're not trying to apply the ROUND to the result but to one of the
intermediate terms, you can use =G4*ROUND(0.076/12,6), for example.
--
David Biddulph