Excel - IF Function Problem - Expert Solution

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

I need a formula that will show the amount in the adjacent column if there is no date entered. If there is a date entered I need it to show a zero dollar balance. Example: Column J47 is a date Column K47 is a dollar amount Column L47 needs to show the dollar amount of K47 if there is no date entry in J47
Solved by S. H. in 15 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 03/04/2018 - 04:02
Hi
Excelchat Expert 03/04/2018 - 04:02
Welcome to Got it Pro
Excelchat Expert 03/04/2018 - 04:02
can you paste the sample data so that i can help you with the formula
Excelchat Expert 03/04/2018 - 04:06
please refer to column A to C
Excelchat Expert 03/04/2018 - 04:07
or J47 to L47
Excelchat Expert 03/04/2018 - 04:07
=IF(J47="",K47,"")
Excelchat Expert 03/04/2018 - 04:07
using this formula in l47 will give dollar value if no date is present in J47
Excelchat Expert 03/04/2018 - 04:07
i have used if function for this
Excelchat Expert 03/04/2018 - 04:07
hope this helps
Excelchat Expert 03/04/2018 - 04:08
Excelchat Expert 03/04/2018 - 04:08
it really helps
Excelchat Expert 03/04/2018 - 04:13
are you there?
User 03/04/2018 - 04:13
yes, sorry it's my first time here
Excelchat Expert 03/04/2018 - 04:13
ok no issues
Excelchat Expert 03/04/2018 - 04:13
have a look at the formula i have used
Excelchat Expert 03/04/2018 - 04:13
hope it helps you out
User 03/04/2018 - 04:14
this works but I need the value to reflect zero if there is a date
Excelchat Expert 03/04/2018 - 04:14
=IF(J47="",K47,0)
Excelchat Expert 03/04/2018 - 04:14
use this now
Excelchat Expert 03/04/2018 - 04:15
does it help now?
Excelchat Expert 03/04/2018 - 04:15
User 03/04/2018 - 04:15
OMG! Your amazing! Thank you so much for the help. Your very fast!
Excelchat Expert 03/04/2018 - 04:15
Thanks
Excelchat Expert 03/04/2018 - 04:15
Please do give good rating and review
Excelchat Expert 03/04/2018 - 04:15
it really helps
User 03/04/2018 - 04:16
where do I do that?
Excelchat Expert 03/04/2018 - 04:16
when you end the session you will get a popup to provide your rating
User 03/04/2018 - 04:17
Most definitely will do.I was making my formulas way too complicated! lol!
Excelchat Expert 03/04/2018 - 04:17
thanks
User 03/04/2018 - 04:17
have a great day!
Excelchat Expert 03/04/2018 - 04:17
you too

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.