# Multiple Formulas in same Cell

This is a discussion on Multiple Formulas in same Cell within the Excel Questions forums, part of the Question Forums category; Is there a way to use multiple formulas for just one cell without damaging the others? Thanks!...

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

Thanks!

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

3. 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.

4. 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 ?

5. 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...

6. ## Fraction rounding

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

7. ## Re: Multiple Formulas in same Cell

Try

=ROUND(90+12.493,1)

8. ## 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

9. ## Re: Multiple Formulas in same Cell

sorry for the inconvenience , i will follow the proceedure
tks

10. ## 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!!!

Page 1 of 2 12 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•