Either or Formula

[Gunzz]

Good Day to all of you smarter than me,

I need help... I am trying to do an either or formula and can't get it. Here are the details:

- In cell A1&2 I need a person to be able to enter Julian dates which translate to a calendar date (dd-mmm-yy) into B1&2 respectively. This portion is complete!

- In cell B3 I needs it to either SUM(B2-B1) if there are entries from the above formulas or make it read zero if B1&2 are blank. B3 can't be blank and I can't get it accomplished.

The current track I'm on and can't get to work:

B3: =IF(A3="",SUM(B2-B1),C3)

I can get it to sum or read zero but I can't get it to do an either or check and input.

Please help and thank you,

Gunz

 

[AliGW]

Maybe this, if I have understood correctly:

=IF(A3<>"",C3,IF(AND(B1="",B2=""),0,B2-B1))

 

[Gunzz]

Thanks for the reply Ali. I will have to try this when I get back to my computer. I do need to add that A3 is an empty cell and holds no weight in any part of my sheet. If this changes things I'm all ears (eyes).

Thanks again!

Gunz

 

[AliGW]

You are confusing me! Why was your attempt this:

=IF(A3="",SUM(B2-B1),C3)

if A3 bears no relevance to the query???

If that is so, then surely all you need is this:

=IF(AND(B1="",B2=""),0,B2-B1)

 

[Gunzz]

? Because I'm new to this and an amateur. I appreciate you and your help.

Thank you,

Gunz

 

[Gunzz]

Ali,

The first one worked perfectly. The second one didn't work. I remember why I was working the formula I was on. Because I needed a single empty block (which would never change on my spreadsheet) to try and make it read the either or if blank.

Thanks again and you were very helpful,

Gunz

 

[AliGW]

You're welcome!