| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logic Statements | Excel Discussion (Misc queries) | |||
| "Reading"the logic behind too-long command statements | Excel Worksheet Functions | |||
| Excel Logic Statements | Excel Discussion (Misc queries) | |||
| IRR Logic | Excel Worksheet Functions | |||
| Can you stop charts from plotting logic statements as 0 | Charts and Charting in Excel | |||
Linear Mode
