Thread: If Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shelly Shelly is offline
external usenet poster
 
Posts: 84
Default If Formula

I can not find the correct formula for the following scenario:

Cell "a" has a number in it. I need cell "c" to show a set default number
if the number is column "a" is greater than the set number and for it to show
the exact number is column "a" if the value is less than the set number.

IE: cell a = 5,868 cell c to show 5,868 since it is less than 11,000
--
Shelly