Question description:
This user has given permission to use the problem statement for this
blog.
Hello
I want to write an IF formula on excel to say:
If cell A4 has no USD, then multiply cell C4 by cell D4
Thanks
Solved by E. Y. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
15/08/2017 - 06:25
No that's all thank you
User
15/08/2017 - 06:25
I would like to calculate the notional
Excelchat Expert
15/08/2017 - 06:25
Hi, Thank you for using Got It Pro.
Excelchat Expert
15/08/2017 - 06:25
I’m happy to be able to help you today.
User
15/08/2017 - 06:26
Thanks for your offer to help :-)
Excelchat Expert
15/08/2017 - 06:26
ok so if no USD is found then C4 is multiplied by D4
Excelchat Expert
15/08/2017 - 06:26
if it is found though what should it do?
User
15/08/2017 - 06:26
Yes
User
15/08/2017 - 06:27
Actually it's a long formula where this is part of it
User
15/08/2017 - 06:27
I can copy out the long formula for you
Excelchat Expert
15/08/2017 - 06:27
Entering Explanation Phase
Excelchat Expert
15/08/2017 - 06:27
no need
Excelchat Expert
15/08/2017 - 06:27
I worked around it
Excelchat Expert
15/08/2017 - 06:28
Please check E2 and test it by changing A2
User
15/08/2017 - 06:29
Can I stick your new formula into my long formula to complete the picture where there are 3 scenarios
Excelchat Expert
15/08/2017 - 06:29
Entering Discussion Phase
Excelchat Expert
15/08/2017 - 06:29
please paste your formula in the sheet
User
15/08/2017 - 06:31
The Error part of the formula is where I plan to stick your new formula in so as to complete the picture
User
15/08/2017 - 06:32
Sorry have I confused you
Excelchat Expert
15/08/2017 - 06:33
no worries
Excelchat Expert
15/08/2017 - 06:33
I got it
Excelchat Expert
15/08/2017 - 06:35
try it now
User
15/08/2017 - 06:37
can you put it in the bottom EUR/GBP row?
Excelchat Expert
15/08/2017 - 06:37
how is it going?
Excelchat Expert
15/08/2017 - 06:37
I did
Excelchat Expert
15/08/2017 - 06:37
the thing is you don't have a value in D8
Excelchat Expert
15/08/2017 - 06:38
it's a text
Excelchat Expert
15/08/2017 - 06:38
so it will return an error
User
15/08/2017 - 06:38
sorry it should be D * F
Excelchat Expert
15/08/2017 - 06:38
D is not a value
User
15/08/2017 - 06:39
sorry C * F
Excelchat Expert
15/08/2017 - 06:39
ok
User
15/08/2017 - 06:39
oh cool
Excelchat Expert
15/08/2017 - 06:40
Is there anything else I can help you with regarding this matter?
User
15/08/2017 - 06:40
Just so i understand: there are 3 scenarios and therefore 3 IFs statements with 3 formulas for each scenario?
Excelchat Expert
15/08/2017 - 06:40
yes
Excelchat Expert
15/08/2017 - 06:41
Is there anything else I can help you with regarding this matter?
User
15/08/2017 - 06:41
thanks, how can I save this sheet down?
Excelchat Expert
15/08/2017 - 06:41
https://docs.google.com/spreadsheets/d/19H3LLzIPNiwQ_e5hz4DGlbf8OkJcZ0JBThzJwY0yryY/edit
Excelchat Expert
15/08/2017 - 06:42
open this link
Excelchat Expert
15/08/2017 - 06:42
then file download as
Excelchat Expert
15/08/2017 - 06:42
excel spreadsheet
User
15/08/2017 - 06:42
thanks for your help :)
Excelchat Expert
15/08/2017 - 06:42
My pleasure
Excelchat Expert
15/08/2017 - 06:43
Have a great day