Cable Forum - View Single Post

MaccLad · 15-02-2022, 18:27

C1
=if(a1>b1,a1-b1,"")
copy/drag that value down for c2, c3, etc

D1
=if(b1>a1,b1-a1,"")
copy/drag that down for d2, d3, etc

15-02-2022, 18:27	#2
MaccLad cf.member Join Date: Jul 2005 Location: Cheshire Posts: 29	Re: Excel Question please C1 =if(a1>b1,a1-b1,"") copy/drag that value down for c2, c3, etc D1 =if(b1>a1,b1-a1,"") copy/drag that down for d2, d3, etc