Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Math Bug
"fred" wrote...
.... Ignorance -- I hope you meant "not knowing", not "being an idiot." Yes. I admit to my own ignorance from time to time. There's nothing wrong with ignorance as long as it's addressed once discovered. Now, elsewhere in this thread I mentioned that Excel really isn't mathematical software but an overgrown calculator, and Excel's unary minus operator works like HP [CHS] or TI [+/-] keys when pressed before their respective [x^y] keys. FWIW, that's the best mnemonic I can offer. However, if you want to avoid ambiguity at the cost of some loss of flexibility, use Excel's POWER function instead of the ^ operator. Does the same thing without ambiguity. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Less Excel more Math | Excel Worksheet Functions | |||
Math functions in Excel | Excel Discussion (Misc queries) | |||
Excel math formula | Excel Worksheet Functions | |||
How do I ? math/excel question | Excel Discussion (Misc queries) | |||
More math than excel, but a fun problem | Excel Worksheet Functions |