Thread
:
Newbie Question
View Single Post
#
5
Posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
Posts: 2,345
Newbie Question
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
Replace @mailinator.com with @tiscali.co.uk
"Francis Whitaker" wrote in
message m...
Well I mean I'm at a loss here...
The logic test section seems to be limited to answering a true or false
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 display
the result of a math calculation as an output. Any help would be
greatly appreciated.
--
Francis Whitaker
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann