I want to create a formula that takes cell F7 and divides it by 3. If the result is a decimal with two places, I want that number. If it is a decimal with more than 2 places, I want to print "error".
Example: F7 = 244.50. 244.50/3 is 81.50. I want to print 81.50
Example: F7 = 81.50. 81.50/3 is 20.375. I want to print "error"
I tried this:
F8 = F7/3
IF(ROUND(F8, 2) = F8, F8, "error")
This did not work.
Example: F7 = 244.50. 244.50/3 is 81.50. I want to print 81.50
Example: F7 = 81.50. 81.50/3 is 20.375. I want to print "error"
I tried this:
F8 = F7/3
IF(ROUND(F8, 2) = F8, F8, "error")
This did not work.