View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Corradus Corradus is offline
external usenet poster
 
Posts: 1
Default Struggling with IF formula...is it even the right one for me?

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.

How do I sculpt a formula for this?