Remember Me?

#1
July 14th 07, 02:16 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 64
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=D-E
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

#2
July 14th 07, 02:36 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 383
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=D-E
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
July 14th 07, 02:44 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 64
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=D-E
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
July 14th 07, 04:10 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 64
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=D-E
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
July 18th 07, 09:42 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 383
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

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=D-E
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Andre van Wyk Excel Worksheet Functions 5 June 14th 07 01:09 PM mbdbiz Excel Discussion (Misc queries) 2 August 10th 06 04:26 AM mbdbiz Excel Worksheet Functions 3 August 10th 06 01:18 AM C Anderson Excel Worksheet Functions 3 April 12th 06 03:31 AM roy.okinawa Excel Worksheet Functions 4 November 15th 05 06:01 AM

All times are GMT +1. The time now is 09:02 AM.