Re: Logic Statements

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

From: LW (LW_at_discussions.microsoft.com)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 10:07:04 -0800

Okay, I fixed that to:
=IF((((D12*$O$4)-Y12)/$AB$4)>0,"(((D12*$O$4)-Y12)/$AB$4),"1.0")
 But it changes all my calculations to 1.0 now regardless if it is positive
or negative.

"LW" wrote:

> That didn't work unfortunately, it just tells me that there is an error with
> the formula and wants to add a second set of quotes around "1.0". When I
> accept it, it just makes all the values say the word "False".
>
> "Bob Phillips" wrote:
>
> > =IF((((D12*$O$4)-Y12)/$AB$4)>0,"(((D12*$O$4)-Y12)/$AB$4),"1.0")
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "LW" <LW@discussions.microsoft.com> wrote in message
> > news:845797B4-94DD-44FF-9597-19CBEED20843@microsoft.com...
> > > I need a little help with my logic statement. I want for it to display a
> > > "1.0" if the calculation is less than zero and to display the real number
> > if
> > > greater than zero. This is as far as I can get.
> > > Thanks!
> > > =IF((((D12*$O$4)-Y12)/$AB$4)>0,,"1.00")
> >
> >
> >

Relevant Pages

  • RE: How do I calculate an age in Access?
    ... Gunny ... > suppose to include the Set InsAge portion, if so, I did. ... >> information that the calculations are based upon can change, ... >> HTH. ...
    (microsoft.public.access.queries)
  • Re: Finding the most recent months (or whatever) data
    ... How about just designating 2 cells where you enter a starting date and ... ending date for your calculations? ... Try this to average closing if closing was in Column E and dates are in ... Okay, I've made a good bit of progress (have also been reading ...
    (microsoft.public.excel.misc)
  • Re: OT: Michael Richards
    ... use it dozens of times in one routine? ... If it is okay for them to use it, why is it horrible for a ... HTH. ... It was then a majority black city. ...
    (alt.sports.baseball.bos-redsox)
  • Re: Eric Rucker hints that Sharepoint is driving Access/Jet features?
    ... > behind-the-scenes with a properly normalized structure. ... notion that multiple vlaues in a field is okay which means that people will also ... I feel the same way about the fact that SQL Server now has calculated fields at ... to tell people that you don't store calculations in tables. ...
    (comp.databases.ms-access)
  • Re: COUNT with Multiple Criteria Error
    ... Works okay for me in a small test.Try reducing the number of rows, ... HTH ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)