The formula in column "Q" needs an additional (IF TRUE, IF FALSE) parameter, but I can't figure out how to add it.
I would like to adjust the formula so that IF D95=1, E95=W, D96=2, E96=W, & D97 <>=3 THEN Q95 = (M96*2+M95)
The formula in column "Q" needs an additional (IF TRUE, IF FALSE) parameter, but I can't figure out how to add it.
I would like to adjust the formula so that IF D95=1, E95=W, D96=2, E96=W, & D97 <>=3 THEN Q95 = (M96*2+M95)
is this what you want??
=IF(AND(D95=1,E95="W",D96=2,E96="W",D97<>3),(M96*2)+M95,0)
Windy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks