Prev: IF THEN Statement
Next: finding duplicate addresses across 2 worksheets in the same workbo
From: Neil Humphries on 11 Feb 2010 13:16
Is the second IF really needed? Would not IF(B12>=0,B12*0.4,0) solve the
problem more simply?

Also, since 0*0.4 = 0 it could be simplified to IF(B12>0,B12*0.4,0).

If the test only occurs a few times there won't be a noticable difference,
but if the test happens hundreds of times then the last formula will be
faster.



"Eva" wrote:

> IF(B12>=0,B12*0.4,IF(B12,0,0))
> Click yes if helped
> --
> Greatly appreciated
> Eva
>
>
> "barbara h" wrote:
>
> > Help! If cell B12 >= 0, then I need the answer to be calculated based on the
> > formual "B12 * .40". If cell B12 < 0, then the answer is zero.
> >
> > How do I do this?
> > --
> > barbara h
From: Mike H on 11 Feb 2010 14:01
Neil,

You don't need an IF statement at all, have a look at other responses
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Neil Humphries" wrote:

> Is the second IF really needed? Would not IF(B12>=0,B12*0.4,0) solve the
> problem more simply?
>
> Also, since 0*0.4 = 0 it could be simplified to IF(B12>0,B12*0.4,0).
>
> If the test only occurs a few times there won't be a noticable difference,
> but if the test happens hundreds of times then the last formula will be
> faster.
>
>
>
> "Eva" wrote:
>
> > IF(B12>=0,B12*0.4,IF(B12,0,0))
> > Click yes if helped
> > --
> > Greatly appreciated
> > Eva
> >
> >
> > "barbara h" wrote:
> >
> > > Help! If cell B12 >= 0, then I need the answer to be calculated based on the
> > > formual "B12 * .40". If cell B12 < 0, then the answer is zero.
> > >
> > > How do I do this?
> > > --
> > > barbara h
First  |  Prev  | 
Pages: 1 2
Prev: IF THEN Statement
Next: finding duplicate addresses across 2 worksheets in the same workbo