Topic starter
Having trouble with nested function. I want column c to show the diference between columns A/B, but then if that =0, I want the value in C to auto change to 1.
Apologies & thanks.
Posted : 03/11/2011 11:04 am
=if(A-b = 0, 1, A-B)
Posted : 03/11/2011 11:06 am
c1=if(a1=b1,1,a1-b1) innit?
Posted : 03/11/2011 11:08 am
Topic starter
ta
Posted : 03/11/2011 11:08 am