**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.*