| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hopefully easy one to answer !!
Paul You can use a simple IF formula: =IF((D3*5-E3-G3-I3-K3-M3-O3)<0,0,D3*5-E3-G3-I3-K3-M3-O3) in cell P3. Hope this helps! Richard -- RichardSchollar ------------------------------------------------------------------------ RichardSchollar's Profile: http://www.excelforum.com/member.php...o&userid=34698 View this thread: http://www.excelforum.com/showthread...hreadid=545796 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hopefully easy one to answer !!
Hi Paul,
One way: =MAX(D3*5-E3-G3-I3-K3-M3-O3, 0) --- Regards, Norman "Paul Cooke" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hopefully easy one to answer !!
Many thanks Richard - works perfectly :) Thanks again Pau -- Paul Cook ----------------------------------------------------------------------- Paul Cooke's Profile: http://www.excelforum.com/member.php...fo&userid=2926 View this thread: http://www.excelforum.com/showthread.php?threadid=54579 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hopefully easy one to answer !!
=max(0,D3*5-E3-G3-I3-K3-M3-O3 )
will do it for you |
| Reply |
| 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)
Linear Mode
