Multiple Formulas in a single Cell

Hi,

It's not clear what result you're expecting to see and what you mean by 'putting them together'.

Do you mean the second SUM() formula is dependent on the IF condition in the first formula and should apply if the IF test is false. In which case try

Please Login or Register  to view this content.

otherwise upload an example workbook and show what result you expect to see.

I have a spread sheet where Column F is called Price, With in This Column F5-F65536 I need both of the above Formulas in there, I am not sure how to go about this, I know obviously how to put a formula in a cell but not how to have two seperate one in there.

I have tried the above code you gave but this does not work.

Basically I want to calculate the cost with =SUM(D5*E5) but if in C5 the word "Daily Total" appears then =IF(C37="Daily Total",SUM(OFFSET($F$1,MATCH(MAX($G$3:G36),G:G,0),0,MATCH(MAX($G$3:G38),G:G,0)-MATCH(MAX($G$3:G36),G:G,0)-1,1)),"") will come in to action. I hope this makes sense.

I can not upload a sample due to work restrictions, but if you let me have an e-mail address I can e-mail it to you.

Thanks

Shazz

Hi,

Try

Please Login or Register  to view this content.

Although I'm not sure why you want to test for Daily Total twice. Generally if you have two IF Tests make one the default result of the other.