Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hello, this is my problem. I have a value in cell A1 which I want to calculate and put in cell A4 based on variable values in cell A2 and A3. Cell A2 can be given values £ and $ Cell A3 can be give values IN or OUT What I would like the formula to do is: A4= if A2 is £ AND A3 is IN then A4=A1, if not A4=0 but at tej same time if A2 is $ AND A£ is IN then A4=A1* a value I decide, if not A4=0. Ca you please help me?
Solved by M. H. in 29 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 15/08/2018 - 11:01
Hello
Excelchat Expert 15/08/2018 - 11:01
Welcome
User 15/08/2018 - 11:02
thanks
User 15/08/2018 - 11:02
hello to you
Excelchat Expert 15/08/2018 - 11:02
Nice to meet you.
Excelchat Expert 15/08/2018 - 11:02
Would you be able to show me some sample data on the blank spreasheet?
User 15/08/2018 - 11:02
sure.
User 15/08/2018 - 11:02
Cna I copy and paste?
Excelchat Expert 15/08/2018 - 11:02
Of course.
Excelchat Expert 15/08/2018 - 11:02
Please go ahead.
User 15/08/2018 - 11:04
so, I would lie to eliminate colums D and E
User 15/08/2018 - 11:04
andwork only in G H I J
Excelchat Expert 15/08/2018 - 11:05
You want to delete column D and E from the spreadsheet?
User 15/08/2018 - 11:05
and have the problems solved as addressed above
Excelchat Expert 15/08/2018 - 11:07
Sorry, I'm having trouble to relate the description with the example data.
User 15/08/2018 - 11:07
OK.
User 15/08/2018 - 11:07
Lets start fresh
Excelchat Expert 15/08/2018 - 11:07
Thank you.
User 15/08/2018 - 11:08
This form helps me keep track of cash flow based on different ucrrencies
User 15/08/2018 - 11:08
A has the currency
User 15/08/2018 - 11:08
B the amount
User 15/08/2018 - 11:09
C the Exchange rate
User 15/08/2018 - 11:09
F tells me is the money is coming in or going out
User 15/08/2018 - 11:09
G and H convert everything to poubds
User 15/08/2018 - 11:09
I and J convert everything to euros
User 15/08/2018 - 11:10
and place it in the correct column
Excelchat Expert 15/08/2018 - 11:10
Okay, I'm listening.
User 15/08/2018 - 11:10
I want to eliminate D and E which purely calculate the conversion rates
User 15/08/2018 - 11:11
and have an IF statement in G and H, or I and J, that will allow me to have all calculations to be done there
User 15/08/2018 - 11:11
so, for example
User 15/08/2018 - 11:13
G will be, If A is £ and F is in, then G = B if not G=0 BUT, at the same tine, IF A is € and F is IS then G = (b*c), if got G=0
Excelchat Expert 15/08/2018 - 11:14
I believe I understand the problem now.
Excelchat Expert 15/08/2018 - 11:14
Please give me a few minutes to write a formula.
User 15/08/2018 - 11:14
great !
User 15/08/2018 - 11:17
mmmm...thatb looks like a nested excel formula
User 15/08/2018 - 11:18
I am not sure it has enough arguments
Excelchat Expert 15/08/2018 - 11:18
Please extend time when you are asked, I need more time.
User 15/08/2018 - 11:18
OK
Excelchat Expert 15/08/2018 - 11:18
Yeah, the formula I wrote wasn't correct. I'll let you know when I've the complete formula.
User 15/08/2018 - 11:19
Ok
User 15/08/2018 - 11:19
thanks
User 15/08/2018 - 11:23
that will work probably by changing the currency value
Excelchat Expert 15/08/2018 - 11:23
Let's see.. I'm still working on it.
Excelchat Expert 15/08/2018 - 11:26
Alright, I'm done. Please check the results.
Excelchat Expert 15/08/2018 - 11:26
I've also deleted the previous column D and E.
User 15/08/2018 - 11:27
Works wonders
User 15/08/2018 - 11:27
Thank you
User 15/08/2018 - 11:27
!!!
Excelchat Expert 15/08/2018 - 11:27
I'm glad you approve.
User 15/08/2018 - 11:27
How do I get the formula and how do I pay you?
Excelchat Expert 15/08/2018 - 11:27
Please consider rating me 5 star if you think my service was helpful.
Excelchat Expert 15/08/2018 - 11:28
I'm giving the formulas.
User 15/08/2018 - 11:28
Absolutely !!1
User 15/08/2018 - 11:28
Very well thought
Excelchat Expert 15/08/2018 - 11:28
=IF(A2="€",IF(D2="in",B2/C2,0),IF(D2="in",B2,0)) is for pound-in
User 15/08/2018 - 11:28
I liked the approach
User 15/08/2018 - 11:28
clean
Excelchat Expert 15/08/2018 - 11:28
=IF(A2="€",IF(D2="out",B2/C2,0),IF(D2="out",B2,0)) is for pound-out
Excelchat Expert 15/08/2018 - 11:29
Thank you for the appreciation.
User 15/08/2018 - 11:29
let me check
Excelchat Expert 15/08/2018 - 11:29
=IF(A2="€",IF(D2="in",B2,0),IF(D2="in",B2*C2,0)) is for euro-in
Excelchat Expert 15/08/2018 - 11:29
=IF(A2="€",IF(D2="out",B2,0),IF(D2="out",B2*C2,0)) is for euro-out.\
User 15/08/2018 - 11:29
wonderful
User 15/08/2018 - 11:29
got them all
Excelchat Expert 15/08/2018 - 11:30
You can also download the file by clicking on File menu. File->Download As->Excel Document
User 15/08/2018 - 11:30
mega
User 15/08/2018 - 11:30
thanks
Excelchat Expert 15/08/2018 - 11:31
Thank you too, for visiting us. Please click on the End button now to close the chat and rate me.
User 15/08/2018 - 11:31
thanks !!
Excelchat Expert 15/08/2018 - 11:31
Have a great day!
User 15/08/2018 - 11:31
you too1

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.