Excel, solve multiple simple subtraction?
I'm trying to get excel to solve b1-b2, but I'm trying to get it also to do c1-c2,d1-d2 and so on.
Also, if the answer is 1, it should say "A", another number, 3 should give "B" and so on.
I'm trying to get excel to solve b1-b2, but I'm trying to get it also to do c1-c2,d1-d2 and so on.
Also, if the answer is 1, it should say "A", another number, 3 should give "B" and so on.
Anonymous
this will work if those are the only two letters A and B, but the more you add, the more 'nested' your if statement becomes...
=IF(B1-B2=1,"A","B")
then copy this formula down