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.
