LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jim Lowe
 
Posts: n/a
Default HOW CAN I MAKE A FORMULA RETURN A ZERO

I am working with an inventory analysis spread sheet and want to calculate
projected orders and need to change negative calculations to zero so that I
can get a total number of all items required.


 
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
Why does my formula return zero? was Excel Discussion (Misc queries) 11 May 26th 05 09:49 PM
Date formula: return Quarter and Fiscal Year of a date Rob Excel Discussion (Misc queries) 7 May 11th 05 08:48 PM
find formula and return value Micayla Bergen Excel Discussion (Misc queries) 5 May 2nd 05 02:52 PM
FORMULA TO MAKE CELL COLOR CONTINGENT FORMULA QUESTION Excel Discussion (Misc queries) 5 March 7th 05 04:49 PM
How do I make a formula for precentages? doddlebugger Excel Worksheet Functions 4 November 17th 04 01:43 AM


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