Help with an IF Formula

		Microsoft Office Forums > Microsoft Excel > Excel
Help with an IF Formula

08-17-2017, 07:29 AM

NBVC

Windows 10 Help with an IF Formula

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

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))

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
Formula Help	MSWARTZEL	Excel	1	03-01-2016 02:34 PM
Need help with IF formula	SMI	Word	3	01-19-2016 06:33 AM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
Formula help	furface00	Excel	10	02-26-2012 05:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:52 PM.