i have cell E5 & F5 to imput either quantity in pieces or in total linear feet to show in cell A5, so far i have the 2 conditions when input is in E5 this is the formula =IF(E5>0,E5*21," ") , when input is in F5 this is the formula =IF(F5>0,ROUNDUP(F5/21,0)*21," ") ,what i am trying to do is the following : the formula should only allow 1 input from either E5 or F5
Solved by O. W. in 13 mins