If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




How do i add multiple formulas in one cell for excel?
If i have a formula A=B+C and there is also another way to get "A", A=DE
How can i put them in the same cell? Like, if i don't have a value for B&C, but have values for D&E it will calculate it. Thank you, M 
Ads 
#2




How do i add multiple formulas in one cell for excel?
maybe simple formula setup? if not what need, repost, will modify:
=IF(X1="","",IF(AND(B1<>"",C1<>""),B1+C1,IF(AND(D1 <>"",E1<>""),D1+E1,""))) "M" wrote: > If i have a formula A=B+C and there is also another way to get "A", A=DE > How can i put them in the same cell? > Like, if i don't have a value for B&C, but have values for D&E it will > calculate it. > > Thank you, > M 
#3




How do i add multiple formulas in one cell for excel?
i think i get some of it. Whats the "" mean? if i know what, then i can
understand it. "nastech" wrote: > maybe simple formula setup? if not what need, repost, will modify: > > =IF(X1="","",IF(AND(B1<>"",C1<>""),B1+C1,IF(AND(D1 <>"",E1<>""),D1+E1,""))) > > "M" wrote: > > > If i have a formula A=B+C and there is also another way to get "A", A=DE > > How can i put them in the same cell? > > Like, if i don't have a value for B&C, but have values for D&E it will > > calculate it. > > > > Thank you, > > M 
#4




How do i add multiple formulas in one cell for excel?
just a side note, i'm trying to figure out what "A" would be.
"M" wrote: > i think i get some of it. Whats the "" mean? if i know what, then i can > understand it. > > "nastech" wrote: > > > maybe simple formula setup? if not what need, repost, will modify: > > > > =IF(X1="","",IF(AND(B1<>"",C1<>""),B1+C1,IF(AND(D1 <>"",E1<>""),D1+E1,""))) > > > > "M" wrote: > > > > > If i have a formula A=B+C and there is also another way to get "A", A=DE > > > How can i put them in the same cell? > > > Like, if i don't have a value for B&C, but have values for D&E it will > > > calculate it. > > > > > > Thank you, > > > M 
#5




How do i add multiple formulas in one cell for excel?
hi, sorry took so long to get back.
A looks like would just be the output, what you would see as a result; I believe that is why formula's start with a equal "=" sign. the double hack marks refer to nothing. formula's are a boolean algebra approach with: IF(this,then this,else that) the last 2 parts are reversable, i.e.: with IF(this,TRUE,FALSE) order kept, you can fix your result for TRUE or FALSE output. Use Help to lookup index for functions: starting with: IF, AND, OR, TRUE, FALSE, NOT, Operators (=, +, , <> not equal, > greater than, < less than...) Errors might occur if you do not allow for FALSE Conditions to be addressed in the formula. The reversable part talking about: IF(false conditions,"", otherwise if false conditions are true, perform the next equations you enter. that is why the example I gave included a double hash at the end, to include all 3 parts of the formula.  "M" wrote: > just a side note, i'm trying to figure out what "A" would be. > > "M" wrote: > > > i think i get some of it. Whats the "" mean? if i know what, then i can > > understand it. > > > > "nastech" wrote: > > > > > maybe simple formula setup? if not what need, repost, will modify: > > > > > > =IF(X1="","",IF(AND(B1<>"",C1<>""),B1+C1,IF(AND(D1 <>"",E1<>""),D1+E1,""))) > > > > > > "M" wrote: > > > > > > > If i have a formula A=B+C and there is also another way to get "A", A=DE > > > > How can i put them in the same cell? > > > > Like, if i don't have a value for B&C, but have values for D&E it will > > > > calculate it. > > > > > > > > Thank you, > > > > M 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Combining multiple formulas in one cell  Andre van Wyk  Excel Worksheet Functions  5  June 14th 07 01:09 PM 
Please help! I need multiple formulas for one cell!  mbdbiz  Excel Discussion (Misc queries)  2  August 10th 06 04:26 AM 
Help! I need multiple formulas for one cell.  mbdbiz  Excel Worksheet Functions  3  August 10th 06 01:18 AM 
Multiple Formulas in same cell  C Anderson  Excel Worksheet Functions  3  April 12th 06 03:31 AM 
multiple formulas in one cell  roy.okinawa  Excel Worksheet Functions  4  November 15th 05 05:01 AM 