Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
the place where you get a negative enter the following
=min(0,your formula that makes the value zero) "Jim Lowe" <Jim wrote in message ... 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. |
#3
![]() |
|||
|
|||
![]()
"Jim Lowe" wrote:
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. Check for a negative value and replace with 0 if true =IF(A1<0,0,A1) |
#4
![]() |
|||
|
|||
![]()
utilize the if function...
if("your calculation <0,0,your calculation) "Jim Lowe" <Jim wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why does my formula return zero? | Excel Discussion (Misc queries) | |||
Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
find formula and return value | Excel Discussion (Misc queries) | |||
FORMULA TO MAKE CELL COLOR CONTINGENT | Excel Discussion (Misc queries) | |||
How do I make a formula for precentages? | Excel Worksheet Functions |