Newbie Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Francis Whitaker - 14 Mar 2008 05:44 GMT

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

Signature

Francis Whitaker

Reply to this Message

Kassie - 14 Mar 2008 08:09 GMT

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

Signature

Hth

Kassie Kasselman
Change xxx to hotmail

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

Reply to this Message

Francis Whitaker - 14 Mar 2008 21:48 GMT

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

--
Francis Whitaker

Reply to this Message

Dave Peterson - 14 Mar 2008 23:24 GMT

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

> Well I mean I'm at a loss here...
>
[quoted text clipped - 6 lines]
> --
> Francis Whitaker

Signature

Dave Peterson

Reply to this Message

Sandy Mann - 14 Mar 2008 23:26 GMT

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.

Signature

HTH

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

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Well I mean I'm at a loss here...
>
[quoted text clipped - 3 lines]
> the result of a math calculation as an output. Any help would be
> greatly appreciated.

Reply to this Message

Rate this thread: