LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zul Zul is offline
external usenet poster
 
Posts: 7
Default if negative figure

I want to how to put a formula for the beow requirement.

sum of two cells, if i get a postive asnswer I want to display it, if I get
a negative answer i want to display 0(zero)

Thanks

Zul
 
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
Changing color of negative bar when using Invert if negative Breck Charts and Charting in Excel 9 March 4th 08 12:40 PM
Using a negative figure as positive cal_coach_26 Excel Discussion (Misc queries) 5 October 10th 07 04:37 AM
Set negative numbers to zero. Do not calculate with negative valu Excel Headache Excel Discussion (Misc queries) 4 September 14th 06 08:56 PM
how to find negative figure in various columns and rows HOW TO GO TO SHEET1 FROM WHILE WORKING I Excel Discussion (Misc queries) 2 January 25th 06 08:52 AM
2003= negative number&2004= negative number How Do I Calculate gro Jason Excel Worksheet Functions 1 January 14th 05 05:24 PM


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