how do i add a function to a formula?

D

david_b2

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

Nick Hodge

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

[email protected]
www.nickhodge.co.uk
 
L

Loris

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.
 
H

hot dogs

if for example you have a formula like =if(A1>10,"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(A1>10,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.
 
D

David Biddulph

david_b2 said:
I would like to add the "Round" function to a formula like,
"=G4*(0.076/12)"
Click to expand...

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.
 
D

david_b2

Thanx that was exactly what I was looking for!

David Biddulph said:
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.
Click to expand...
 
D

david_b2

Thanx that was exactly what I was looking for.

David Biddulph said:
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.
Click to expand...
 
Top