Here are some problems that our users have asked and received explanations on
Want help for IF, OR, AND functions for large data base. Unable to prepare a correct logic with IF, OR, AND function in excel. Please help.
Solved by B. H. in 27 mins
I have 4 columns in Excel and need to write an If OR statement to flag if data is in one or more columns
Solved by B. H. in 24 mins
Hi, i need some help with writing a complex excel formula using a multiple if / if and / if or statement.
Solved by B. A. in 11 mins
Need help to writ the following excel formula: if a = 1 and b = 2 or 3 or 4 then X
Solved by X. Y. in 22 mins
I need help with this formula-for 1 cell if cell c13 = 1 and (if(e13 =1 or f13=1 or g13=1 or h13=1 or I13 =1) =1))then value = $d$6 *$D$9 or if cell d13 = 1 and ( if(e13 =1 or f13=1 or g13=1 or h13=1 or I13 =1) =1)) then value = $d$5 *$D$9 or If cell (c13 = 1 and if J13 =1) then value = $E$6 *$D$9 or If cell (d13 = 1 and if j13 =1) then value = $F$6 *$D$9 If cell (c13 = 1 and if k13 =1) then value = $E$5 *$D$9 or If cell (d13 = 1 and if k13 =1) then value = $F$5 *$D$9