Multiple Formulas in a single Cell

**Shazz** · 01-09-2012, 09:09 AM

Can anyone help at all, I have two formulas i need to have in one cell, I do not know how to correctly put them together, please see below formulas.

Can anyone let me know how to do this.

=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)),"")

=SUM(D5*E5)

I would very much appreciate someones help.

Shazz
x

**Whizbang** · 01-09-2012, 09:16 AM

Please explain what you mean by "put them together". Do you just want to concatenate the results? What cells are these formulas in?

If possible, please provide a sample workbook to further illustrate your problem and desired result.

**Richard Buttrey** · 01-09-2012, 09:18 AM

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

=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)),SUM(D5*E5))

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

**Shazz** · 01-10-2012, 03:58 AM

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

**Richard Buttrey** · 01-10-2012, 06:02 AM

Hi,

Try

=IF(C$5="Daily Total",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)),""),d5*E5)

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.