View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BCB BCB is offline
external usenet poster
 
Posts: 1
Default Can TRUE/FALSE be replaced by a formula?


Hi


I was wondering if, given that the conditions (for a "1" or "TRUE") are
in place, say: A3B3, wouldn't it be possible for Excel to return the
difference between A3 and B3 ("A3-B3"), for instance, or any other
cells' additions or subtractions for that matter?
It gets worse: instead of piling these returns in a column beside the A
and B columns, would it be possible to sum these conditional additions
in a single cell on top?

Hope someone knows the tricks and can help
Thanks in advance
bcb


--
BCB
------------------------------------------------------------------------
BCB's Profile: http://www.excelforum.com/member.php...o&userid=34101
View this thread: http://www.excelforum.com/showthread...hreadid=567321