I am trying to nest a formula and it does not work. Can anyone tell me what
is wrong and how to correct it. The forumla is;
=IF(sum(ReturnTemp-105)<=10,((PresentSupplyTemp-105)>27,27,(PresentSupplyTemp-105)),0).
--
Thanks for your help
Arnold
I am trying to nest a formula and it does not work. Can anyone tell me what
is wrong and how to correct it. The forumla is;
=IF(sum(ReturnTemp-105)<=10,((PresentSupplyTemp-105)>27,27,(PresentSupplyTemp-105)),0).
--
Thanks for your help
Arnold
To fix your formula:
=IF((ReturnTemp-105)<=10,IF((PresentSupplyTemp-105)>27,27,PresentSupplyTemp-105),0)
To shorten it a bit:
=IF(ReturnTemp<=115,MIN(PresentSupplyTemp-105,27),0)
To shorten it a bit more:
=(ReturnTemp<=115)*MIN(PresentSupplyTemp-105,27)
Tim C
"dutchtreet" <[email protected]> wrote in message
news:[email protected]...
>I am trying to nest a formula and it does not work. Can anyone tell me
>what
> is wrong and how to correct it. The forumla is;
> =IF(sum(ReturnTemp-105)<=10,((PresentSupplyTemp-105)>27,27,(PresentSupplyTemp-105)),0).
> --
> Thanks for your help
> Arnold
Not sure what the ouctomes are supposed to be but my best guess at what you
are doing:-
=IF((ReturnTemp-105)<=10,IF((PresentSupplyTemp-105)>27,27,PresentSupplyTemp-
105))
You either had too many arguments in there for what you had, or not enough
arguments to be able to use the 0 as an option. If that's not doing it then
tell us what the logic in the formula is meant to be for what you are trying
to do
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"dutchtreet" <[email protected]> wrote in message
news:[email protected]...
> I am trying to nest a formula and it does not work. Can anyone tell me
what
> is wrong and how to correct it. The forumla is;
>
=IF(sum(ReturnTemp-105)<=10,((PresentSupplyTemp-105)>27,27,(PresentSupplyTem
p-105)),0).
> --
> Thanks for your help
> Arnold
Hi!
Maybe this:
=IF(ReturnTemp-105<=10,IF(PresentSupplyTemp-
105>27,27,PresentSupplyTemp-105),0)
Biff
>-----Original Message-----
>I am trying to nest a formula and it does not work. Can
anyone tell me what
>is wrong and how to correct it. The forumla is;
>=IF(sum(ReturnTemp-105)<=10,((PresentSupplyTemp-105)
>27,27,(PresentSupplyTemp-105)),0).
>--
>Thanks for your help
>Arnold
>.
>
Oops - that 0 wasn't superfluous after all
=IF((ReturnTemp-105)<=10,IF((PresentSupplyTemp-105)>27,27,PresentSupplyTemp-
105),0)
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Ken Wright" <[email protected]> wrote in message
news:[email protected]...
> Not sure what the ouctomes are supposed to be but my best guess at what
you
> are doing:-
>
>
=IF((ReturnTemp-105)<=10,IF((PresentSupplyTemp-105)>27,27,PresentSupplyTemp-
> 105))
>
> You either had too many arguments in there for what you had, or not enough
> arguments to be able to use the 0 as an option. If that's not doing it
then
> tell us what the logic in the formula is meant to be for what you are
trying
> to do
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> --------------------------------------------------------------------------
--
> It's easier to beg forgiveness than ask permission :-)
> --------------------------------------------------------------------------
--
>
> "dutchtreet" <[email protected]> wrote in message
> news:[email protected]...
> > I am trying to nest a formula and it does not work. Can anyone tell me
> what
> > is wrong and how to correct it. The forumla is;
> >
>
=IF(sum(ReturnTemp-105)<=10,((PresentSupplyTemp-105)>27,27,(PresentSupplyTem
> p-105)),0).
> > --
> > Thanks for your help
> > Arnold
>
>
Thankyou for your help.
Arnold
"Ken Wright" wrote:
> Oops - that 0 wasn't superfluous after all
>
> =IF((ReturnTemp-105)<=10,IF((PresentSupplyTemp-105)>27,27,PresentSupplyTemp-
> 105),0)
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "Ken Wright" <[email protected]> wrote in message
> news:[email protected]...
> > Not sure what the ouctomes are supposed to be but my best guess at what
> you
> > are doing:-
> >
> >
> =IF((ReturnTemp-105)<=10,IF((PresentSupplyTemp-105)>27,27,PresentSupplyTemp-
> > 105))
> >
> > You either had too many arguments in there for what you had, or not enough
> > arguments to be able to use the 0 as an option. If that's not doing it
> then
> > tell us what the logic in the formula is meant to be for what you are
> trying
> > to do
> >
> > --
> > Regards
> > Ken....................... Microsoft MVP - Excel
> > Sys Spec - Win XP Pro / XL 97/00/02/03
> >
> > --------------------------------------------------------------------------
> --
> > It's easier to beg forgiveness than ask permission :-)
> > --------------------------------------------------------------------------
> --
> >
> > "dutchtreet" <[email protected]> wrote in message
> > news:[email protected]...
> > > I am trying to nest a formula and it does not work. Can anyone tell me
> > what
> > > is wrong and how to correct it. The forumla is;
> > >
> >
> =IF(sum(ReturnTemp-105)<=10,((PresentSupplyTemp-105)>27,27,(PresentSupplyTem
> > p-105)),0).
> > > --
> > > Thanks for your help
> > > Arnold
> >
> >
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks