Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dealing with minus numbers in formulas
I'm adding the values from 3 cells using the formula =SUM(C61,C63,C64) . The value in cell C63 is calculated by a formula =SUM(C62*0.4) which can sometimes produce a minus figure. When the figure in C63 is a minus number, I want it to show a 0, so that the minus number is not factored in to the sum of cells C61,C63,C64. Hope that makes sense! Any suggestions gratefully received! -- duubgina ------------------------------------------------------------------------ duubgina's Profile: http://www.excelforum.com/member.php...o&userid=34867 View this thread: http://www.excelforum.com/showthread...hreadid=546187 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dealing with minus numbers in formulas
In progress I'm adding the values from 3 cells using the formula =SUM(C61,C63,C64) . The value in cell C63 is calculated by a formula =SUM(C62*0.4) which can sometimes produce a minus figure. When the figure in C63 is a minus number, I want it to show a 0, so that the minus number is not factored in to the sum of cells C61,C63,C64. Hope that makes sense! Any suggestions gratefully received! Replace =SUM(C61,C63,C64) with =SUM(C61,C63*(C630),C64) -- CaptainQuattro ------------------------------------------------------------------------ CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763 View this thread: http://www.excelforum.com/showthread...hreadid=546187 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dealing with minus numbers in formulas
Try:
=IF(C63<0,C61+C64,C61+C63+C64) "duubgina" wrote: I'm adding the values from 3 cells using the formula =SUM(C61,C63,C64) . The value in cell C63 is calculated by a formula =SUM(C62*0.4) which can sometimes produce a minus figure. When the figure in C63 is a minus number, I want it to show a 0, so that the minus number is not factored in to the sum of cells C61,C63,C64. Hope that makes sense! Any suggestions gratefully received! -- duubgina ------------------------------------------------------------------------ duubgina's Profile: http://www.excelforum.com/member.php...o&userid=34867 View this thread: http://www.excelforum.com/showthread...hreadid=546187 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dealing with minus numbers in formulas
duubgina: Maybe this: =C61+C64+MAX(C63,0) Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=546187 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dealing with minus numbers in formulas
=SUM(C61,MAX(0,C63),C64) .
ed |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dealing with minus numbers in formulas
In C63 use one of
(a) =IF(C62<0,0,C62*0.4) or (b) =(C62*0.4)*(C620) For the summation use =C61+C63+C64 No need to clutter cells with SUM every time you code a simple formula best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "duubgina" wrote in message ... I'm adding the values from 3 cells using the formula =SUM(C61,C63,C64) . The value in cell C63 is calculated by a formula =SUM(C62*0.4) which can sometimes produce a minus figure. When the figure in C63 is a minus number, I want it to show a 0, so that the minus number is not factored in to the sum of cells C61,C63,C64. Hope that makes sense! Any suggestions gratefully received! -- duubgina ------------------------------------------------------------------------ duubgina's Profile: http://www.excelforum.com/member.php...o&userid=34867 View this thread: http://www.excelforum.com/showthread...hreadid=546187 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with searching for characters | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
what are the formulas to minus from excel | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Formulas for telephone numbers: finding duplicates, autoformat | Excel Worksheet Functions |