Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent - make formula work with both decimal separators
I have a customer who has in my mind a strange request:
In cell A3 I have the formula =A1*A2 The value in A2 is always the same but the user is allowed to enter a value in A1 and my customer wants to make the calculation in A3 work no matter if the user enters a value with "." or "," as decimal separator. As it is now if the user enters a value with the opposit decimal separator compared to standard in A1 the result in A3 is ########. How can I solve this? Regards, S |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent - make formula work with both decimal separators
=IF(ISERROR(FIND(",",A1)),A1,VALUE(SUBSTITUTE(A1," ,",".")))
If your standard decimal separaor = ".", otherwise the other way around. -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message oups.com... |I have a customer who has in my mind a strange request: | | In cell A3 I have the formula =A1*A2 | | The value in A2 is always the same but the user is allowed to enter a | value in A1 and my customer wants to make the calculation in A3 work no | matter if the user enters a value with "." or "," as decimal separator. | | As it is now if the user enters a value with the opposit decimal | separator compared to standard in A1 the result in A3 is ########. | | How can I solve this? | | Regards, | | S | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
one formula to make a multiplication table work | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do I make an If-Then formula in Excel? | Excel Worksheet Functions |