Microsoft Office Forums - View Single Post - Help with an IF Formula

Thread: Help with an IF Formula

View Single Post

Old

08-17-2017, 07:29 AM

NBVC

NBVC is offline

NBVC uses Windows 10

Windows 10 NBVC uses Office 2013

NBVC uses Office 2013

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC will become famous soon enough

Default

Assuming your prediction is in B2:B3, then try:

=IF(AND(A2=B2,A3=B3),3,IF(SIGN(A2-A3)=SIGN(B2-B3),1,0))

Reply With Quote