Since I doubt that an accounting spreadsheet ever expects to actually use complex numbers, I would expect the first solution to be the simplest and most appropriate. The solution you choose depends entirely on your reason for using the IMSUB() function. Arguments in a formula are written inside Parentheses (). If you do not use a separator, Excel will read your references as a single entity and may not work. Similarly, references are usually separated by a comma sign (,) in a formula. With complex numbers, one would use =IMREAL(IMSUB(.)), but one could also use any number of other strategies for converting numbers stored as text to numbers. Excel will only read your data as a formula once you start it with the equals sign. This results in a number (not text).Ģ) Add to the formula something will convert from text to a number. solutions I see:ġ) Use a regular subtraction operator =B28-C25. Number formatting does not change the display of text strings (which includes numbers stored as text like in this case). The IMSUB() function is designed to work with complex numbers, which are stored in Excel cells as text strings, so the IMSUB() function returns a text string - even if the inputs are all real and the output is real. You are dealing with all real numbers, so I wonder why you are using the IMSUB() function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |