Question description:
This user has given permission to use the problem statement for this
blog.
Hi, just need a bit of help with this IF statement:
=IF(Z499="Open",[AB499-B499],[Z499])
Solved by M. W. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
12/09/2018 - 01:07
Hello, Welcome to Got it Pro.
Excelchat Expert
12/09/2018 - 01:08
How may I help you today?
User
12/09/2018 - 01:08
can you fix my IF statement please?
User
12/09/2018 - 01:08
=IF(Z499="Open",[AB499-B499],[Z499])
Excelchat Expert
12/09/2018 - 01:08
What is the problem?
Excelchat Expert
12/09/2018 - 01:09
Can you add some sample data at the right side of the screen and then I can help you better.
User
12/09/2018 - 01:10
ok, can i take control of the .xls please?
Excelchat Expert
12/09/2018 - 01:10
You can add from row 4 onwards
Excelchat Expert
12/09/2018 - 01:10
just leave first 2 rows
User
12/09/2018 - 01:10
OK
Excelchat Expert
12/09/2018 - 01:12
I have added two row 2 and row 3... I guess that is what you want?
User
12/09/2018 - 01:13
yes, that looks right
Excelchat Expert
12/09/2018 - 01:13
if it is open than subtract otherwise same value (open or closed)
User
12/09/2018 - 01:13
correct
Excelchat Expert
12/09/2018 - 01:13
wait
Excelchat Expert
12/09/2018 - 01:14
=IF(Z499="Open",(AB499-B499),[Z499)
Excelchat Expert
12/09/2018 - 01:14
Trying using this, just corrected your formula
Excelchat Expert
12/09/2018 - 01:14
oops
Excelchat Expert
12/09/2018 - 01:14
=IF(Z499="Open",AB499-B499,Z499)
Excelchat Expert
12/09/2018 - 01:14
this one
Excelchat Expert
12/09/2018 - 01:14
I hope it will serve your purpose
Excelchat Expert
12/09/2018 - 01:15
Did it solve your query?
User
12/09/2018 - 01:15
perfect - thank you :)
Excelchat Expert
12/09/2018 - 01:15
Please end the session, I will appreciate a 5 star rating. I will also provide a 5 star rating for you so that you get the best expert next time.
Excelchat Expert
12/09/2018 - 01:15
Thanks for using Got it Pro. Looking forward to help you further.
Appreciate it :)
Excelchat Expert
12/09/2018 - 01:15
Have a good day :)
User
12/09/2018 - 01:15
thanksm 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.