Logic Statements
 

seems to be all your formulas are giving you the answer -1.10

the formula shown should be correct, check your numbers... or sub in
real numbers to check the formula first..


--
ehflam
------------------------------------------------------------------------
ehflam's Profile: http://www.excelforum.com/member.php...o&userid=16779
View this thread: http://www.excelforum.com/showthread...hreadid=319804

Logic Statements
 

No, the numbers are fine. I have used the same calculation to compute the
numbers before pasting this new formula into the same cell. None of them
equal -1.10.

"ehflam" wrote:


seems to be all your formulas are giving you the answer -1.10

the formula shown should be correct, check your numbers... or sub in
real numbers to check the formula first..


--
ehflam
------------------------------------------------------------------------
ehflam's Profile: http://www.excelforum.com/member.php...o&userid=16779
View this thread: http://www.excelforum.com/showthread...hreadid=319804

Logic Statements
 

It works for me mate!

--

HTH

RP
(remove nothere from the email address if mailing direct)


"LW" wrote in message
...
No, the numbers are fine. I have used the same calculation to compute the
numbers before pasting this new formula into the same cell. None of them
equal -1.10.

"ehflam" wrote:


seems to be all your formulas are giving you the answer -1.10

the formula shown should be correct, check your numbers... or sub in
real numbers to check the formula first..


--
ehflam
------------------------------------------------------------------------
ehflam's Profile:
http://www.excelforum.com/member.php...o&userid=16779
View this thread:
http://www.excelforum.com/showthread...hreadid=319804

Logic Statements
 

My copy of the spreadsheet must've been corrupted. It worked on my other copy.

Thanks for your help.

"Bob Phillips" wrote:

It works for me mate!

--

HTH

RP
(remove nothere from the email address if mailing direct)


"LW" wrote in message
...
No, the numbers are fine. I have used the same calculation to compute the
numbers before pasting this new formula into the same cell. None of them
equal -1.10.

"ehflam" wrote:


seems to be all your formulas are giving you the answer -1.10

the formula shown should be correct, check your numbers... or sub in
real numbers to check the formula first..


--
ehflam
------------------------------------------------------------------------
ehflam's Profile:
http://www.excelforum.com/member.php...o&userid=16779
View this thread:
http://www.excelforum.com/showthread...hreadid=319804