Get instant live expert help on I need help with excel if equals
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
If Q2 equals 100, Calculate comm in X2 (A2*T2) (same row) Next Row until Q equals 100 again If Q3 equals 0, Calculate comm in X3 (A3*T2) If Q4 equals 0, Calculate comm in X4 (A4*T2) If Q5 equals 100, Calculate comm in X5 (A5*T5) (same row) Next Row until Q equals 100 again If Q6 equals 0, Calculate comm in X6 (A6*T5)
Solved by C. W. in 27 mins
If Value equals 320 or less divide by 3.5 %if value equals over 320 divide by 5%
Solved by G. W. in 21 mins
I have the following equations below that i need to combine and turn it into a formula. If D6 equals anywhre from 0 - 29 only, and G3 equals anywhere from 0 - 2 only, then it is F6 + H6. If D6 equals anywhere from 30 - 39 only, and G3 equals anywhere from 0 - 3 only, then it is F6 + H6. If D6 equals anywhere from 40 - 100 only, and G3 equals anywhere from 0 - 4 only, then it is F6 + H6 Otherwise, 0.
Solved by M. Y. in 28 mins
I need a formula that meets this criteria, If Cell A3 is >8 then Cell A6 equals 454, if Cell A3 is <8>4 then Cell A6 equals 290, if Cell A3 is <=4>0.1 then Cell A6 equals 169, if Cell A3 is <=0 then Cell A6 equals 0
Solved by O. Y. in 26 mins
Can anyone help me create this function: equals F1 if B4 is > or = to F1; equals F2 if B4 is <= F2
Solved by O. J. in 25 mins