Posted to microsoft.public.excel.misc

external usenet poster

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

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

All times are GMT +1. The time now is 07:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us