View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Emlf25 Emlf25 is offline
external usenet poster
 
Posts: 2
Default Maximum value of a cell

I'm trying to set the maximum value of a cell to 10 but can't seem to get it
right.

Here's my formula so far, any idea's please?

=SUM(B30-140)