LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE Nad.Engoor Excel Worksheet Functions 3 December 30th 08 03:04 PM
need help with if statement that calculate minimum figure KateZed Excel Worksheet Functions 2 November 17th 08 06:41 PM
Returning contents of a cell based upon the minimum value in a ran Shawn Excel Worksheet Functions 4 September 2nd 07 08:48 PM
How to lookup the minimum, 2nd minimum and 3rd minimum......... Mark McDonough Excel Worksheet Functions 8 July 15th 06 09:39 PM
minimum a fixed figure when it is lower weepel New Users to Excel 5 June 22nd 05 06:46 PM


All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"