View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
m m is offline
external usenet poster
 
Posts: 64
Default 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