Newbie Question

[Francis Whitaker]

Is it possible to make the excel IF function give me the result of a
mathematical calculation as an output?

 

[Kassie]

Your question is rather vague, but the answer is most likely yes. It depends
on what you want to do, and how you phrase your IF statement

 

[Francis Whitaker]

Well I mean I'm at a loss here...

The logic test section seems to be limited to answering a true or fals
question. And the logic test is always a comparison between two values
So i'm just trying to figure out if it is really possible to displa
the result of a math calculation as an output. Any help would b
greatly appreciated

 

[Dave Peterson]

=if(a1=b1,a1*b1+sqrt(c1)-average(d1:e3),a1-3*b1)

 

[Sandy Mann]

You don't explain what you mean by *math calculation.* If the *math
calculation* was say (A5+D5)/F5 then the IF() formula could be something
like:

=IF(COUNT(A5,D5,F5)=3,(A5+D5)/F5,"")

This will show the result of the calculation only if all three cells have
values.

Post back with more information so that we can help you.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk