Forum Discussion
Solved
Help with an Excel Formula/Command Please
Good Afternoon, I need help with a formula which I am trying to put into an Excel Spreadsheet please. I'm not sure how to do what I want to do. Please See The Diagram Below. I am wanting to put...
- Glad to help. Based on your screenshots, I thought cells I3:I6 were merged, which means the value is stored in I3. It looks like you merged I4:I6, which is why your correction worked! I really glad that this caused you to do some research and learn about some awesome formula capabilities in Excel.
Please mark one of my responses as the Best Response. Thanks!
You can use nested IF statements to achieve the desired result. This should work:
=IF(I3=G3,H3,IF(I3=G4,H4,IF(I3=G5,H5,IF(I3=G6,H6))))
If this answers your request, please consider marking it as the approved solution. Thank you!
Hi Don - UPDATE - You were exactly right - it was just that you had 1 simple error in your formula (very easy to do).
The I3 (which was the reference cell) should have been I4
I used your formula & substituted I4 for your I3 & it worked perfectly. Brilliant, thank you.
I must admit that by having this small error in your response to me, it made me think a lot about 'Nested IF statements', so I learn't a lot (Deliberate on your part ? 🙂 )
Thank you again for your help Don,
Kind Regards,
Andrew (Gold Coast, Australia)
The I3 (which was the reference cell) should have been I4
I used your formula & substituted I4 for your I3 & it worked perfectly. Brilliant, thank you.
I must admit that by having this small error in your response to me, it made me think a lot about 'Nested IF statements', so I learn't a lot (Deliberate on your part ? 🙂 )
Thank you again for your help Don,
Kind Regards,
Andrew (Gold Coast, Australia)
- Glad to help. Based on your screenshots, I thought cells I3:I6 were merged, which means the value is stored in I3. It looks like you merged I4:I6, which is why your correction worked! I really glad that this caused you to do some research and learn about some awesome formula capabilities in Excel.
Please mark one of my responses as the Best Response. Thanks!Looks like the updated version1.5 didn't attach & send last message........
Here it is,
Kind Regards,
Andrew
Don Kirkham Hi Don, thank you again for your help. Your response was definitely the best response and I did have every intention of marking it this way. Unfortunately & have been away from my office & on the road working for 2 days. Now I am back, I see that you have marked the response appropriately. Sorry you had to beat me to the task. I have successfully completed the workbook I was creating & learned a lot more about the awesome power of Microsoft Excel in the process.
I have attached a copy of the finished workbook, as you may be interested in what I was doing ? It relates to cryptocurrency trading 🙂
Kind Regards,
Andrew
- Hi Don,
I told you I am still learning a lot.
Regarding my Workbook, I discovered that I needed to write a simple Macro & assign it to a button to allow users to ‘Update the Currency Exchange Rates’ & that it doesn’t happen automatically !
I hope have attached the updated Version 1.5 (only because I thought you may be interested in the project I did.) I'll leave you alone now.
Kind Regards,
Andrew.
