Thread: Limit on Logic
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
  
Posts: 733
Default Limit on Logic
Harlan Grove wrote...
....
=TEXT(MIN(10,ROUNDUP(D2,0))*25,"0;""N/A""")

Screwed that up. Make that

=TEXT(MIN(10,INT(D2))*25,"0;""N/A""")

Reply With QuoteReply With Quote