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.
|