Using two equations in one cell

[rholmes1303]

I currently have a spreadsheet that has to calculate two things. One is an age difference between one person and their spouse. Excel will only calculate the difference if the first cell in the equation greater than the second. I would have to change the equation everytime the person in the second cell of the equation was older than the first. This has become a big inconvienince, so my question is how can I make two equations apply to one cell and have excel use whichever equation works and not use the equation that gives me the ######### or #VALUE! response. Thanks for any help!

 

[VoG]

Maybe like this

=MAX(A1,B1)-MIN(A1,B1)

 

[rholmes1303]

DATEDIF(C9,C8,"y")&" years "&DATEDIF(C9,C8,"ym")&" months "

This is the equation i am using.... I would have to switch the C9 and C8 in the equation, I want to put the same equation twice in the same cell with the cells switched around and have excel use whichever works

 

[VoG]

Try


=DATEDIF(MIN(C8,C9),MAX(C8,C9),"y")&" years "&DATEDIF(MIN(C8,C9),MAX(C8,C9),"ym")&" months "

 

[Jonmo1]

Perhaps

=ABS(A1-B1)

 

[rholmes1303]

VoG... that worked perfectly! Thanks!