I want a cell to reflect a value from 1-5 based on what is entered in 5 adjacent cells: OutreachActuals UpdatedLog in Days since last LogonUse Mobile Interact with Primaryyesyes6/28/20180?yesIf A1=yes, than G1=1If A1=yes and B1=yes, G1=2If A1=yes, B1=yes, D1<90, G1=3If A1=yes, B1=yes, D1<90, E1=yes, G1=4If A1=yes, B1=yes, D1<90, E1=yes, F1=yes, G1=5 How do I express this in a formula? Many thanks!

Forum Discussion

Copper Contributor

Jun 28, 2018

I want a cell to reflect a value from 1-5 based on what is entered in 5 adjacent cells:

Outreach	Actuals Updated	Log in	Days since last Logon	Use Mobile	Interact with Primary
yes	yes	6/28/2018	0	?	yes

If A1=yes, than G1=1

If A1=yes and B1=yes, G1=2

If A1=yes, B1=yes, D1<90, G1=3

If A1=yes, B1=yes, D1<90, E1=yes, G1=4

If A1=yes, B1=yes, D1<90, E1=yes, F1=yes, G1=5

How do I express this in a formula? Many thanks!