Thread: Returning A Minimum Figure
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hammer[_2_] Hammer[_2_] is offline
external usenet poster
  
Posts: 6
Default Returning A Minimum Figure
Cell D9 =sum of Cell D8 (12.5) minus cell D3 (4) giving an answer of 8.5.

How do i get cell D9 to show a minumum of 9 if the answer falls below 9.
Reply With QuoteReply With Quote