Excel - IF Function Problem - Expert Solution

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