| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trigonometry & Math functiona in Excel
A29=(C10-C37)/2*(TAN(RADIANS(B27)))
C10=12.5 feet B27=55 degrees C37=0.9 feet answer=8.283 feet (Correct result) The above formula works. Why the formula below does not work? Does not give the correct result. A29=(C10-(C37*0.0833)/2*(TAN(RADIANS(B27)))) I am simply changing C37 from decimal of feet into inches Can someone help with this dilemma please? Many thanks in advance. Serge |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract MS Excel Data embedded in MS Word | Excel Discussion (Misc queries) | |||
| Sharing read-write Excel 2003 files | Excel Discussion (Misc queries) | |||
| Excel Math problem | Excel Worksheet Functions | |||
| Excel Math formulas | Excel Discussion (Misc queries) | |||
| Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
