Need a formula to set a field based on two variables

		Microsoft Office Forums > Microsoft Excel > Excel
Need a formula to set a field based on two variables

01-12-2016, 10:51 AM

unknownhere2000 unknownhere2000 is offline

Windows XP Need a formula to set a field based on two variables

Office 2013

Novice

Join Date: Jan 2016

Posts: 2

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.

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Array to iterate through variables and trap blank variables	Marrick13	Word VBA	5	08-04-2015 06:19 AM
Creating new field in pivot table based off existing field	laceymarie1987	Excel	0	06-26-2014 12:13 PM
Formula Field using Field Codes	hunter2193	Word	3	04-05-2013 04:58 AM
Calculating a cell value based on many variables	malawimick	Excel	0	12-14-2011 05:29 PM
Formula to subtract one month from due date field in reminder field	ghumdinger	Outlook	1	10-01-2011 12:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 PM.