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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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