Date: 06/26/05 (Microsoft Windows)    Keywords: no keywords

I have two cells with carying numbers in them. In another cell, I want to do the following:

Basically, I want it to compare the contents of those two cells. If they're equal, use that number. If one is lower, use that lower number instead, unless that lower number is zero, in which case it needs to use the higher number.

I'm seeing a LOT of IF statements here, and I'm hoping there's a way to shorten this formula down.

Source: http://www.livejournal.com/community/ms_windows/37802.html