Danieltoro
New member
- Joined
- Feb 27, 2022
- Messages
- 14
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- 2021
[FONT=Segoe UI, Helvetica Neue, Helvetica, Roboto, Oxygen, Ubuntu, Cantarell, Fira Sans, Droid Sans, sans-serif]Apologies but I had this query today in another forum but unable to upload the attached excel file had to use this forum instead which I now it's not ideal but don't have the add-in required.
I have used the below formula in column K but only works up to column 14, also giving error in row 4 if you can help pls[/FONT]
=IFERROR(G2/IF(H2="CNY",J2,J3),"")
I have used the below formula in column K but only works up to column 14, also giving error in row 4 if you can help pls[/FONT]
=IFERROR(G2/IF(H2="CNY",J2,J3),"")