LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TSK TSK is offline
external usenet poster
 
Posts: 21
Default How to set minus value to 0

How to focus the value to zero after minus from 2 cells otherwise show the
actual value different?

A1 - 100 / B1 - 50


If B1 - A1 is not <= 0 show the value different and if B1 - A1 is <=0 then
reflect the number as 0
 
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
plus and minus ekkeindoha Excel Worksheet Functions 1 August 29th 07 09:07 AM
Plus or minus help Mark Excel Discussion (Misc queries) 12 July 26th 07 10:30 PM
Minus Unease Excel Discussion (Misc queries) 1 June 19th 07 08:34 AM
CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS Socal Analyst looking for help Excel Discussion (Misc queries) 2 May 12th 06 07:17 PM
Value Minus Value = ??? Emzicle Excel Discussion (Misc queries) 9 August 23rd 05 08:22 PM


All times are GMT +1. The time now is 12:48 AM.

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"