Multiple Formulas in same Cell

gymwrecker

Active Member
Joined
Apr 24, 2002
Messages
390
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Is there a way to use multiple formulas for just one cell without damaging the others?

Thanks!
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
I'm not clear on the multiple formulas for just one cell care to explain a little more
 
Upvote 0
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.
 
Upvote 0
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 ?
 
Upvote 0
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...
 
Upvote 0
Fraction rounding

90.000+
12.493
-------------------------
Result would be 102.493
but i need to formula (sum+round) result as 102.500
 
Upvote 0
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
 
Upvote 0
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!!!
 
Upvote 0

Forum statistics

Threads
1,212,927
Messages
6,110,720
Members
448,294
Latest member
jmjmjmjmjmjm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top