LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Location: Washington DC
Posts: 5
Default Function Conflicts with an If/Then Statement

I am trying to finalize a spreadsheet I have developed, but am having trouble with one of the final cell functions. The function is to compare two cells. Each cell will have a 0, 1 or 2. If the cells are identical then a 0 should appear in a third cell. If one cell is a 0 and the other is a 1 or 2 then a 1 should appear in the third cell. If one cell is a 1 and the other is a 2 then a 0 should appear in a third cell. This is what i would like, but don't know how to write as one cell function:
"If A2 is equal to 0 and A72 is equal to 0 then 0
If A2 is greater than 0 and A72 is greater than 0 then 0
If A2 is equal to 0 and A72 is greater than 0 then 1
If A2 is greater than 0 and A72 is equal to 0 then 1"


the problem is I can't seem to get it right. I always have a conflict where the program says something is false when it is true or true when it is false.

Here is what I have written:
=IF(A2=A72,0)+IF(A20+A720,0)+IF(A2=0+A720,1)+IF (A20+A72=0,1)

Thanks if you have any suggestions
Marshall
 
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
macro sheet name conflicts spence Excel Worksheet Functions 1 June 25th 07 05:05 AM
MATCH FUNCTION AND SERIAL DATE CONFLICTS Jones the Scouse Excel Worksheet Functions 4 November 1st 06 01:46 PM
Save conflicts Donna A Excel Discussion (Misc queries) 0 June 27th 06 02:21 AM
Excel Option Conflicts JB2005 Excel Discussion (Misc queries) 1 August 5th 05 01:07 PM
Excel Option Conflicts JB2005 Excel Discussion (Misc queries) 0 August 4th 05 09:28 PM


All times are GMT +1. The time now is 11:36 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"