| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to show zero if reference cell is zero? tricky!
Hi all, I have a formula that looks at the cell value on one sheet and adds it to the previous value on the original sheet, my problem is this....where this formula appears it shows the last summed value so in this case from S6 down to Sxxx it will show the value £813 because this is the last value it added, in the formula below i would like it to state that if 'Account Entry'!S6 is zero then dont calculate S6+S5 just show zero! is this possible in a formula? =IF('Account Entry'!S6="","0",'Account Entry'!S6+S5) Regards, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=551646 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Threaded Mode
