'Investment sheets has an error while converting usd to eur
I get an error with my code: =IF(ISNUMBER(SEARCH("$",B3),RIGHT(B3,LEN(B3)-1)*A1000,B3)) The error is: Incorrect number of arguments for IF. Expected between 2 and 3 arguments, but found 1 arguments.
It should convert b3 to euros if there is a "$" before the number.A1000= usd/eur in numbers.
The sheet: https://docs.google.com/spreadsheets/d/1RnYi9H70fqS5wy1OQO2jex7xdNl-1kFLVbm3uDjejTg/edit?usp=sharing .I am trying in G/H 29
Solution 1:[1]
try:
=IF(ISNUMBER(SEARCH("$"; B3)); RIGHT(B3; LEN(B3)-1)*A1000; B3)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |