View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
 
Posts: 1,163
Default cross-footing in excel

Not sure exactly what you mean by multiple formulas - a cell can only show
one value; formulas would imply multiple results - unless you mean you want
to check two conditions and return a true/false answer or some sum or
difference based on them. The True/False option can use AND or OR conditions
and would look something like this:
=IF(AND(SUM(A1:A5)=0,SUM(A1:E1)=0),"OK","NOT OK")
You can adjust cell references as needed.
--
- K Dales


"sirsoto" wrote:

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.