Hello all:
Maybe someone can help with this problem!
Cell A1 and B1 contain #'s.
In Cell C1 Im looking to divide the highest value by the lowest value between the two cells but only if there is a value in cell A1.
Here's the formula I tried to use.
Different explanation... if (there's a value in cell A1, (and if the value in cell A1 is < value in cell B1))if true divide A1/B1, if false divide B1/A1.
Only problem with this is.... it's not recognizing the 1st value. I don't have anything in cell A1 and I'm still getting a result in cell C1
Maybe someone can help with this problem!
Cell A1 and B1 contain #'s.
In Cell C1 Im looking to divide the highest value by the lowest value between the two cells but only if there is a value in cell A1.
Here's the formula I tried to use.
Code:
=IF((AND(a1,a1<b1)),a1/b1,b1/a1)
Different explanation... if (there's a value in cell A1, (and if the value in cell A1 is < value in cell B1))if true divide A1/B1, if false divide B1/A1.
Only problem with this is.... it's not recognizing the 1st value. I don't have anything in cell A1 and I'm still getting a result in cell C1