ResellerRatings Store Ratings - View Single Post - Excel Function

strangerstill · 10-21-2002, 03:53 PM

Er... what you wrote has four arguments: b44/c44>3, "OK", b44/c44<3, and "ORDER". IF only accepts 3 arguments. If you want extra tests, you need to nest IFs (by putting an IF() formula in place of value_if_true or value_if_false)

10-21-2002, 03:53 PM	#9 (permalink)
strangerstill Registered User Join Date: Oct 2001 Posts: 1,565	Er... what you wrote has four arguments: b44/c44>3, "OK", b44/c44<3, and "ORDER". IF only accepts 3 arguments. If you want extra tests, you need to nest IFs (by putting an IF() formula in place of value_if_true or value_if_false)