| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Struggling with IF formula...is it even the right one for me?
Mon, 9 Apr 2007 19:56:00 -0700 from Corradus
: Let's say that I have a value in one cell, call it X. X is a numerical value that needs not be touched or modified UNLESS it exceeds another numerical value in another cell, call it Y. If it DOES exceed Y, then it must be made to show as EQUAL to the value in Y. If it doesn't, it can show whatever it is in reality. in X1, put =MIN(whatever, Y1) If "whatever" is smaller, X1 has that value. If "whatever" is larger, X1 has the value of Y1. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Struggling to plot where I want | Charts and Charting in Excel | |||
| Struggling IF value | Excel Discussion (Misc queries) | |||
| Struggling for a solution | Excel Worksheet Functions | |||
| Struggling Again With A VLOOKUP | Excel Worksheet Functions | |||
| Help, I'm Struggling! | New Users to Excel | |||
Threaded Mode
