View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default cross-footing in excel

You should be able to add multiple formulas in a single cell until you
exceed the number of characters allowed in a single cell (I think that is
256)

Of course a lot depends on what you mean by "multiple formulas"
you can't enter =A1+B1 = C1+D1
but you can build an If statement
=If(A10, A1+B1, if(C10, C1+D1))

And you can include multiple functions in a single cell.

Of course there is the real tricky formula
="My sum = " & A1+B1 & "Your sum = " & C1+D1

--
steveB

Remove "AYN" from email to respond
"sirsoto" wrote in message
...
Greetings,

Does excel accept multiple formulas for one cell? For example, I am
preparing my budget and my figures should agree both vertically and
horizontally. However, my horizontal calculation requires an absolute
calculation. Thank you.