Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 383
Default Can TRUE/FALSE be replaced by a formula?

should be fairly easy, but not sure if have all info need?:

=IF(A3B3,A3-B3,"")

"BCB" wrote:


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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 94
Default Can TRUE/FALSE be replaced by a formula?


BCB wrote:
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


Hi BCB,

If I understand you correct then I belive you can use something like
the SUMPRODUCT()

Maybe something along the lines of:

=SUMPRODUCT(--(A1:A10B1:B10),A1:A10+B1:B10)


With your data in A1:A10 and B1:B10

The first argument will do the comparisson and the second the addition
(substraction if you put in - )

Regards,
Bondi

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default Can TRUE/FALSE be replaced by a formula?

If I understand, try

=SUM(IF(A1:A10B1:B10,A1:A10-B1:B10))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"BCB" wrote in message
...

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



  #5   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?


Thank you all

Will try them out, and hopefully tweak them to fit my other needs, or
eventually return with more specific questions.
Thanks
bcb


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 06:30 AM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 06:18 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
Creating a check mark box MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 05:37 PM


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"