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
yes please
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
yeah please
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.