joining seperate formula into 1 cell

Hi all I have 3 separate formula's that work individually and wish to join them into 1 cell. how is this done correctly? these are the 3 separate formula: =IF(F15=0,0,IF(F15=1,0.1,IF(F15<=15,-0.002...

excel

Formulas and Functions

SergeiBaklan

Apr 25, 2019

Alphawolf1 ,

That could be like

=IF(F15=1, 0.1,
   IF(F15>300,
     0.0589*(F15)^0.5897,
     IF(F15 > 15,
        0.2337*(F15)^0.345,
        -0.0027*(F15)^2+0.0719*(F15)+0.1098)))*
(F15<>0)

SergeiBaklan

Diamond Contributor

Apr 25, 2019

Alphawolf1 ,

That could be like

=IF(F15=1, 0.1,
   IF(F15>300,
     0.0589*(F15)^0.5897,
     IF(F15 > 15,
        0.2337*(F15)^0.345,
        -0.0027*(F15)^2+0.0719*(F15)+0.1098)))*
(F15<>0)

Alphawolf1

Copper Contributor

Apr 25, 2019

SergeiBaklan

absolutely brilliant, that works..

many thanks, much appreciated.

SergeiBaklan
Diamond Contributor
Apr 25, 2019
Alphawolf1 , you are welcome

Forum Discussion

joining seperate formula into 1 cell

Resources