Combining three formulas

I have the following three CSE formulas that are in one cell each. I'd like to combine the three formulas into one cell:-

{=($C9="Continental")*SUM(IF($F9:$L9="",0,IF($F9:$L9<0.5,0.5,$F9:$L9)))}

{=($C9="Days")*SUM(IF($G9:$K9="",0,IF($G9:$K9<11/24,11/24,$G9:$K9)))}

{=($C9="Nights")*SUM(IF($F9:$K9="",0,IF($F9:$K9<10/24,10/24,$F9:$K9)))}

How do you want them combined? Add the results together?

Pete

Sorry. No I want the three formulas to work independently but just have them contained in the same cell.

Cell C9 that the formulas reference contains either "Continental", "Days" or "Nights"

Originally Posted by Pete_UK

How do you want them combined? Add the results together?

Pete

Try this:

=IF($C9="Continental",SUM(IF($F9:$L9="",0,IF($F9:$L9<0.5,0.5,$F9:$L9))),IF($C9="Days",SUM(IF($G9:$K9="",0,IF($G9:$K9<11/24,11/24,$G9:$K9))),SUM(IF($F9:$K9="",0,IF($F9:$K9<10/24,10/24,$F9:$K9)))))

Entered with CSE.

Hope this helps.

Pete

Originally Posted by Pete_UK

Try this:

=IF($C9="Continental",SUM(IF($F9:$L9="",0,IF($F9:$L9<0.5,0.5,$F9:$L9))),IF($C9="Days",SUM(IF($G9:$K9="",0,IF($G9:$K9<11/24,11/24,$G9:$K9))),SUM(IF($F9:$K9="",0,IF($F9:$K9<10/24,10/24,$F9:$K9)))))

Entered with CSE.

Hope this helps.

Pete

Fantastic - thank you Pete.

You're welcome - thanks for marking the thread as SOLVED.

Pete