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
please do give good rating
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
please let me know
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.
