I'm not clear on the multiple formulas for just one cell care to explain a little more
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!...
Is there a way to use multiple formulas for just one cell without damaging the others?
Thanks!
I'm not clear on the multiple formulas for just one cell care to explain a little more
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
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 ?
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"
90.000+
12.493
-------------------------
Result would be 102.493
but i need to formula (sum+round) result as 102.500
Try
=ROUND(90+12.493,1)
HTH, Peter
Please test any code on a copy of your workbook.
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:
MattyCode:=ROUND(A1+A2,1)
sorry for the inconvenience , i will follow the proceedure
tks
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!!!
Like this thread? Share it with others