Multiple Formulas in same Cell

gymwrecker · May 3rd, 2002, 06:56 PM

Is there a way to use multiple formulas for just one cell without damaging the others?

Thanks!

Paul B · May 3rd, 2002, 06:58 PM

I'm not clear on the multiple formulas for just one cell care to explain a little more

Anne Troy · May 3rd, 2002, 07:23 PM

Multiple CONDITIONS, yes. Multiple formulas, no.

For instance:

=IF(OR(A1>0,A1<25),"Yes","No")

will return Yes if A1 is between zero and 25, and No if it is zero or less than zero, or greater than 25.

Chris Davison · May 4th, 2002, 03:33 AM

Hold on Dreamboat, let's find out what he wants first...!

=MAX(A1:A20)&" "&MIN(B1:B20) are two different formulae in a single cell (albeit represented by a single formula)

Gymwrecker : if you mean have a cell that says "Monthly sales were" and then has a formula which relates the monthly sales, followed by "and yearly average was" followed by a different formula which computes this, all in the same cell, then the answer is yes....

is this the kind of thing you were thinking of ?

Jack in the UK · May 4th, 2002, 07:59 AM

one cell can carry more or less what you like as long as the syntax is correct one formul??? no you can bolt to many again subject to syntax and yhe & will all continualtion so i see that as what ever goes???

Im with you chris

I beleive what Dreamboat refers to is nesting, not bolting.. nest = 1, bold = more

both will work...

haneefa · Oct 30th, 2010, 02:27 PM

90.000+
12.493
-------------------------
Result would be 102.493
but i need to formula (sum+round) result as 102.500

VoG · Oct 30th, 2010, 02:31 PM

Try

=ROUND(90+12.493,1)

Matty · Oct 30th, 2010, 02:32 PM

Always better to open a new thread if you have a question not directly related to a previous thread.

Nonetheless, assuming 90.000 is in A1 and 12.493 is in A2, try:

Code:

=ROUND(A1+A2,1)

Matty

haneefa · Oct 30th, 2010, 02:36 PM

sorry for the inconvenience , i will follow the proceedure
tks

clevy · Jan 11th, 2012, 12:27 PM

So, I have a question on using multiple formulas as well.... I want the same cell to have these 2 formaulas: =M15-IF(M15>40,40,0) AND =MAX(0,K12-40)
So, if cell A shows 45, I want cell B to show only what is over 40 (5), but if cell A is less than 40 I want cell B to say 0..... does that make any sense? Sorry, I am new to this. Appreciate your help!!!

May 3rd, 2002, 07:23 PM	#3
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	Multiple CONDITIONS, yes. Multiple formulas, no. For instance: =IF(OR(A1>0,A1<25),"Yes","No") will return Yes if A1 is between zero and 25, and No if it is zero or less than zero, or greater than 25. __________________ ~Anne Troy

May 4th, 2002, 07:59 AM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	one cell can carry more or less what you like as long as the syntax is correct one formul??? no you can bolt to many again subject to syntax and yhe & will all continualtion so i see that as what ever goes??? Im with you chris I beleive what Dreamboat refers to is nesting, not bolting.. nest = 1, bold = more both will work... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Oct 30th, 2010, 02:27 PM	#6
haneefa New Member Join Date: Oct 2010 Posts: 9	Fraction rounding 90.000+ 12.493 ------------------------- Result would be 102.493 but i need to formula (sum+round) result as 102.500

Oct 30th, 2010, 02:31 PM	#7
VoG MrExcel MVP Moderator Join Date: Jun 2002 Location: UK 51°34'30.38"N, 0°24'59.13"W Posts: 51,374	Re: Multiple Formulas in same Cell Try =ROUND(90+12.493,1) __________________ HTH, Peter Please test any code on a copy of your workbook.

Oct 30th, 2010, 02:32 PM	#8
Matty Board Regular Join Date: Feb 2007 Location: England Posts: 2,544	Re: Multiple Formulas in same Cell Always better to open a new thread if you have a question not directly related to a previous thread. Nonetheless, assuming 90.000 is in A1 and 12.493 is in A2, try: Code: =ROUND(A1+A2,1) Matty

May 3rd, 2002, 06:56 PM	#1
gymwrecker Board Regular Join Date: Apr 2002 Location: Fort Knox, KY Posts: 249	Is there a way to use multiple formulas for just one cell without damaging the others? Thanks!

May 3rd, 2002, 06:58 PM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	I'm not clear on the multiple formulas for just one cell care to explain a little more

May 4th, 2002, 03:33 AM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Hold on Dreamboat, let's find out what he wants first...! =MAX(A1:A20)&" "&MIN(B1:B20) are two different formulae in a single cell (albeit represented by a single formula) Gymwrecker : if you mean have a cell that says "Monthly sales were" and then has a formula which relates the monthly sales, followed by "and yearly average was" followed by a different formula which computes this, all in the same cell, then the answer is yes.... is this the kind of thing you were thinking of ?

Oct 30th, 2010, 02:36 PM	#9
haneefa New Member Join Date: Oct 2010 Posts: 9	Re: Multiple Formulas in same Cell sorry for the inconvenience , i will follow the proceedure tks

Jan 11th, 2012, 12:27 PM	#10
clevy New Member Join Date: Jan 2012 Posts: 2	Re: Multiple Formulas in same Cell So, I have a question on using multiple formulas as well.... I want the same cell to have these 2 formaulas: =M15-IF(M15>40,40,0) AND =MAX(0,K12-40) So, if cell A shows 45, I want cell B to show only what is over 40 (5), but if cell A is less than 40 I want cell B to say 0..... does that make any sense? Sorry, I am new to this. Appreciate your help!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode