| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hopefully easy one to answer !!
I have 6 sheets on a spread sheet with sheet 1 being a "master" and referenceing sheets 2,3,4,5 & 6 At the moment cell "P3" shows the total number of items that need to be ordered and is coded as follows: =D3*5-E3-G3-I3-K3-M3-O3 on some of the items in "P3" it shows a minus value (as we already have some in stock) is there a way to code this to show zero when the sum equals a minus value Hopefully this is explained well and would appriciate any help that you can offer Many thanks Paul -- Paul Cooke ------------------------------------------------------------------------ Paul Cooke's Profile: http://www.excelforum.com/member.php...o&userid=29268 View this thread: http://www.excelforum.com/showthread...hreadid=545796 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculator Answer Doesn't Match Excel Answer | Excel Discussion (Misc queries) | |||
| An easy answer I'm sure, so why am I stuck? | Excel Discussion (Misc queries) | |||
| This should be easy, but can't find an answer...requesting your in | Excel Worksheet Functions | |||
| new user with easy question? not easy for me | New Users to Excel | |||
| Could one of you experts answer an easy question... | Excel Programming | |||
![Paul Cooke[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
