Hopefully this will help explain:

An IF statement is actually an IF, THEN, ELSE statement. Described in plain
english the formula says:
IF cell D6 / cell D76 = 10
THEN sum the values in cells A1 through A30
ELSE (if D6/D76 does not = 10) sum the values in cells A1 through A30

You don't have to use SUM for the then or else! Foir instance you can test
a cell to see if it's greater than a value and return a letter.

If(a150,"Pass","Fail")



"Don Guillett" wrote:

Can you explain?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"AL" wrote in message
...
Can you use an IF statement with an already existing formula?

Example: cell formula =d6/d7; can I then add an IF statements?

Thanks,
AL