rholmes1303
New Member
- Joined
- Oct 27, 2011
- Messages
- 3
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!