Nested If, Multiple Nested If, IsError

[Rosstamon]

Hello,
I'm stuck here.
Column G is people's names, columns I and J are dates, the formula I’m writing is in column R.

My desired end result is:

If column G contains the name “Ed”, column R should say “N/A”. However, if column G contains a name that is NOT "Ed" AND there are dates in columns I and J then do the math, I – J (I minus J). If there's a date in either column but not both columns, then column R should remain blank. And finally, when the same date is in both columns (I & J) return a result of "0.00".

I have the following formula in column R of my spreadsheet.
=IF(ISERROR(IF(OR(G70="Ed"),"N/A",IF(G70<>"Ed",I70-J70,""))),"",IF(OR(G70="Ed"),"N/A",IF(G70<>"Ed",I70-J70,IF(OR(I70="",J70=""),"",))))

What’s happening is,
- if columns I and J are empty, I get the answer 0.00
- if there is a date in column I but not J I get the spreadsheet representation of that date, i.e. 41607 for November 29, 2013

In both cases, I would like the cell in column R to remain blank

 

[Joe4]

I think this should do it:

=IF(G70="Ed","N/A",IF(OR(I70=0,J70=0),"",I70-J70))

 

[Rosstamon]

I think this should do it:

=IF(G70="Ed","N/A",IF(OR(I70=0,J70=0),"",I70-J70))

Joe4 - I am once again indebted to your brilliance. Can't thank you enough. Your formula was so much easier than I was making it. Not sure how to get to your level, but hope to one day make it there. Thanks again. Have a super day.

 

[lexxie2013]

You could try :

=IF(G2="Ed","N/A",IF(AND(I2<>"",J2<>""),IF(I2-J2=0,"0.00",I2-J2),""))

 

[Joe4]

Joe4 - I am once again indebted to your brilliance. Can't thank you enough. Your formula was so much easier than I was making it. Not sure how to get to your level, but hope to one day make it there. Thanks again. Have a super day.

Your welcome!
Keep working at it, and one day you'll get there!