Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Function returning negative 0
Hi there, I am trying to run a function here but it seems that the function will return a negative value only if the values are as follows. A: 84.90 B: 57.16 C: 27.74 Excel function: =IF((+A-B-C)=A,0,(+B+A-C)) if I am to play around with values B and C. I will be able to get a positive 0. i.e. 57.15, 27.75 or 57.17,27.73 Hope someone can help. Thanks. -- ibertram ------------------------------------------------------------------------ ibertram's Profile: http://www.excelforum.com/member.php...o&userid=28730 View this thread: http://www.excelforum.com/showthread...hreadid=484212 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
CHR() function not working in Excel 2003 | Excel Discussion (Misc queries) | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |