Thread: Newbie Question
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default 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