LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 53
Default If sum greater than 12 use 12

Hi,

I know I've seen questions about this before but haven't got time to search.

Would any kind soul please tell me how I can get excel to look at a value in
column M and if it is larger than 12 use 12 in that column
--
Smudge
 
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
greater than but less than Aaron Excel Discussion (Misc queries) 5 April 21st 07 09:00 PM
if value is greater than # * by 20% if less * by 40 sypher New Users to Excel 1 November 9th 06 06:10 PM
Greater Than but Less than KaraGilsdorf Excel Worksheet Functions 5 October 18th 06 08:42 PM
IF greater than Zero dtruelove Excel Worksheet Functions 6 September 21st 06 03:06 PM
Greater then/less then campsoup1988 Excel Worksheet Functions 5 January 16th 05 07:27 PM


All times are GMT +1. The time now is 08:38 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"