Microsoft Office Forums - View Single Post - [Solved] Need a formula to set a field based on two variables

Thread: [Solved] Need a formula to set a field based on two variables

View Single Post

Old

01-12-2016, 10:51 AM

unknownhere2000 unknownhere2000 is offline

unknownhere2000 is offline

unknownhere2000 uses Windows XP

Windows XP unknownhere2000 uses Office 2013

unknownhere2000 uses Office 2013

Office 2013

Novice

The original poster

Join Date: Jan 2016

Posts: 2

unknownhere2000 is on a distinguished road

Question

Need a formula to set a field based on two variables

I want to create a formula that says, if a value in cell D97 <=1.2499 or if it is >=1.80, then give me the value in D97 else show 1.80.

Reply With Quote