Dear BBSers
Can someone that knows be so kind to help me with an answer to how to formulate something in excel.
I want in one cell to be able to ask multiple IF questions. I am able to do this as one IF but I have to do multiple exchange rate ie USD, EUR, YEN etc, and I am mixing this with a VLOOKUP. I can do them as one statement ie =IF cell number = "USD", VLOOKUP....... but need to add a second and third statement to find EUR & YEN.
Does anyone know?
Thanks in advance.
Can someone that knows be so kind to help me with an answer to how to formulate something in excel.
I want in one cell to be able to ask multiple IF questions. I am able to do this as one IF but I have to do multiple exchange rate ie USD, EUR, YEN etc, and I am mixing this with a VLOOKUP. I can do them as one statement ie =IF cell number = "USD", VLOOKUP....... but need to add a second and third statement to find EUR & YEN.
Does anyone know?
Thanks in advance.
0 commentaires:
Enregistrer un commentaire