I need a formula that will go in A2 and it will say if A1 has a 1 in it, then leave A2 blank. If A1 is blank then put a 1 in A2
I was using this in A2But I don't want it to put a 0 but just leave it blank![]()
=IF(A1=1, 0,1)
I need a formula that will go in A2 and it will say if A1 has a 1 in it, then leave A2 blank. If A1 is blank then put a 1 in A2
I was using this in A2But I don't want it to put a 0 but just leave it blank![]()
=IF(A1=1, 0,1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks