nested formulas

[dutchtreet]

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).

 

[Ken Wright]

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
----------------------------------------------------------------------------

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;

 

[Tim C]

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

 

[Biff]

Hi!

Maybe this:

=IF(ReturnTemp-105<=10,IF(PresentSupplyTemp-
105>27,27,PresentSupplyTemp-105),0)

Biff

 

[Ken Wright]

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
----------------------------------------------------------------------------

Not sure what the ouctomes are supposed to be but my best guess at what you
are doing:-

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]

Thankyou for your help.
Arnold

Oops - that 0 wasn't superfluous after all

=IF((ReturnTemp-105)<=10,IF((PresentSupplyTemp-105)>27,27,PresentSupplyTemp-
105),0)