**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.*