I am trying to compare data from two columns in Excel. I would like to have excel pull the lesser valued cell and post into a 3rd column. However, if one of the cells contains 0 or NULL value I want excel to pull the only remaining value from the other compared cell. Ex. A1=200; B1=100 (I have used an IF statement inthe past for this function =IF(B1<=A1,B1*1). However if A1=200 and B1=0; I need C1 to return the value of 200 not 0. How do I do this?
Thanks. This has given me a headache today.
