Re: Formula solution????

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: kcc (kcconline_at_comcast.NOSPAM.com)
Date: 09/24/04


Date: Fri, 24 Sep 2004 03:32:27 GMT


(L1*L2-L3/L4+7L5^2) has an error. Probably should be
(L1*L2-L3/L4+7*L5^2). I was curious what would happen
if it was typed in as you wrote it and excel corrected as
(L1*L2-L3/L4+L75^2), which assuming L75 is blank,
you get an answer of 8.

"Steve S" <Steve.S.1d2iba@excelforum-nospam.com> wrote in message
news:Steve.S.1d2iba@excelforum-nospam.com...
>
> I'm new to excel and have a problem that I need solved. Can someone
> help? This is what I was givin.
>
> (L1*L2-L3/L4+7L5^2)
>
> L1=5, L2=2, L3=6, L4=3, L5=3
>
> DECIMAL POINT AT 0.
>
>
> I came out with an answer of 8. Not really sure if I did it right or
> not?
>
> Thank You to anyone that replies.
>
>
> --
> Steve S
> ------------------------------------------------------------------------
> Steve S's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=14683
> View this thread: http://www.excelforum.com/showthread.php?threadid=263084
>



Relevant Pages

  • Formula solution????
    ... I'm new to excel and have a problem that I need solved. ... This is what I was givin. ... Steve S ...
    (microsoft.public.excel)
  • Re: Win Explorer crashes when checking drive properties
    ... Steve - thanks for the reply, and there are indeed events with the same ... Two of these extra Administrator folders were created this morning, ... Windows cannot load the user's profile but has logged you on with the ...
    (microsoft.public.win2000.general)
  • Re: added account
    ... is not a domain member. ... Under docs & settings, I have Steve and Steve.OFFICE. ... > That is your profile. ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Member Server Login Slow DMZ-Internal Subnet
    ... Relax, Steve, I was just joking. ... Please direct all replies to the newsgroup so all can benefit. ... Microsoft Windows MVP - Active Directory ...
    (microsoft.public.win2000.security)
  • Re: Disappearing messages.
    ... I've not followed through all the replies, Steve, but the problem may be ... your newsreader and the way it archives your messages. ... >>newsgroup on a server. ...
    (sci.anthropology)