Excel - IF Function Problem - Expert Solution

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

I have created a formula with true and false however would like it to be \$0 if the cells are blank. =IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540)
Solved by O. E. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 04/09/2018 - 07:24
Hello
User 04/09/2018 - 07:24
Hello!
Excelchat Expert 04/09/2018 - 07:24
How are you today?
User 04/09/2018 - 07:24
I am well thank you,. how are you
Excelchat Expert 04/09/2018 - 07:24
I am great, thank you
Excelchat Expert 04/09/2018 - 07:24
Can you please tell me more on the problem you are facing?
Excelchat Expert 04/09/2018 - 07:24
=IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540)
Excelchat Expert 04/09/2018 - 07:25
this is the formula you are using and I assume it working correctly.
User 04/09/2018 - 07:25
I have created a formula that works well - it picks up the values from another sheet and it is good however I would like it to be that is the cells are blank that it is getting the values from, that it appears as \$0
User 04/09/2018 - 07:25
it is working correctly
Excelchat Expert 04/09/2018 - 07:25
You need this formula to return \$0 if the cells are blank
User 04/09/2018 - 07:25
Excelchat Expert 04/09/2018 - 07:25
So which all cells are we talking about?
Excelchat Expert 04/09/2018 - 07:26
'BT Calculator'!C4
User 04/09/2018 - 07:26
sorry I dont quite understand
Excelchat Expert 04/09/2018 - 07:26
'BT Calculator'!D4
Excelchat Expert 04/09/2018 - 07:26
'BT Calculator'!E4
Excelchat Expert 04/09/2018 - 07:27
these are the 3 cells used in the formula
User 04/09/2018 - 07:27
I would like the cell, that the formular is pasted into, to appear as \$0 if the 'BT Calculator'!D4 is blank
User 04/09/2018 - 07:27
ohhh I see, sorry
Excelchat Expert 04/09/2018 - 07:27
Ok. so if D4 = "" , then \$0
User 04/09/2018 - 07:27
if the first one is blank, D4
User 04/09/2018 - 07:27
Excelchat Expert 04/09/2018 - 07:27
Understood. Please allow me aminute
User 04/09/2018 - 07:27
Thanks so much!
Excelchat Expert 04/09/2018 - 07:28
=if('BT Calculator'!D4="",0,IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540))
Excelchat Expert 04/09/2018 - 07:28
Please try this formula
User 04/09/2018 - 07:29
ohhhh it works amazingly!!!!
User 04/09/2018 - 07:29
Thank you so so much
Excelchat Expert 04/09/2018 - 07:29
I just added another If condition in the begining
Excelchat Expert 04/09/2018 - 07:29
which states if D4= "" THEN SHOW 0
Excelchat Expert 04/09/2018 - 07:29
otherwise use the formula
Excelchat Expert 04/09/2018 - 07:29
Also, if you are satisfied with my solution, please go ahead and end the session using the button on the top right hand side and requesting you to provide good feedback and review so that I can continue my services to others.
Excelchat Expert 04/09/2018 - 07:30
Please do the needful, thank you and have a great day ahead!
User 04/09/2018 - 07:30
Thank you again for your help
User 04/09/2018 - 07:30
saved ALOT of time!

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.