F
Francis Whitaker
Is it possible to make the excel IF function give me the result of a
mathematical calculation as an output?
mathematical calculation as an output?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
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
on what you want to do, and how you phrase your IF statement
F
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
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
D
Dave Peterson
=if(a1=b1,a1*b1+sqrt(c1)-average(d1:e3),a1-3*b1)
S
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
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