Nov 3, 2022 #1 jlr123 Technical User Feb 24, 2014 117 US I need a formula that represents the folowing: If b2=c2 and R2>0 then R2 else 0 Could use the help today if possible. Thanks very much!
I need a formula that represents the folowing: If b2=c2 and R2>0 then R2 else 0 Could use the help today if possible. Thanks very much!
Nov 3, 2022 1 #2 Andrzejek Programmer Jan 10, 2006 8,509 US How about: [tt]=IF(AND(B2=C2, R2>0), R2, 0)[/tt] More about AND function here ---- Andy "Hmm...they have the internet on computers now"--Homer Simpson Upvote 0 Downvote
How about: [tt]=IF(AND(B2=C2, R2>0), R2, 0)[/tt] More about AND function here ---- Andy "Hmm...they have the internet on computers now"--Homer Simpson