CAN YOU HELP EXCEL FORMULA?
I'm going to restate your rproblem to be sure it's what you meant, and give the formula. If you find that it's not what you wanted, it should be pretty easy to adjust. It's nested IFs with a couple of ANDs. L242 values are "Yes", "No", or "NA" H8 value is the loan amount L243 will hold your formula to calculate commission. The commission rules are as follows: If L242 is Yes and H8 > 500000 then the commission is .015*H8 If L242 is Yes and 200000 < H8 <= 500000 then the commission is .01*H8 If L242 is Yes and H8 < = 200000 then the commission is 0 If L242 is not Yes, then the commission is 0 In order to show the whole formula here, I have to carriage return. You would just have everything together. (Copy each line to something else and get rid of the carriage returns) Here's the formula: =IF(AND(L242="Yes",H8>500000),.015*H8, IF(AND(L242="Yes",H8>200000), .01*H8,0))
Help with IF formula on excel!!!?
I need to make a if formula with this criteria: Using named ranges, create a formula in cell g4 to display Yes if the number of at fault claims is greater then one and the current rating is greater than two. Both conditions must test true to display Yes; otherwise display No in the cell. Hint: Use a nested IF and AND formula. I have been working on this for a long time and cannot figure out how to correctly set it up.
Help with excel formula!?
The law of cosines is c^2 = a^2 + b^2 - 2abcos(theta) Lets say in your spreadsheet Column A has the labels: Side A, Side B, Theta, and Side C. Then you put your values in Column B. The table below use "-"s to represent spaces. | -Column A- | -Column B- | | ---Side A--- | ------ 3 ------- | | ---Side B--- | ------ 4 ------- | | ----Theta---- | ----- 102 ---- | | ---Side C--- | -- Formula - | Now in Cell B4 you will insert the formula: =SQRT(B1^2 + B2^2 - (2*B1*B2*COS( RADIANS(B3) )))
Help with Excel formula?
Sorry if this sounds dumb but i from 1 to 10 in excel i am at 1!!!! Here is the formula i need. I am making a Masters Picks between friends and i want to know how to get the position they finished to the name. Ok Let me explain.
Excel formula help?
I was wondering if anyone knows the formula in excel to find the average of only the data that meets a certain criteria. For example, in my case I need to find the average GPA's of students and then find the average for just males and just females which is listed in another column. There's like 600 rows so it will be hard to do without the formula. Thanks
Excel formula help?
to put this in the most simple way I can.. I need to put a formula into an excel worksheet that will do exactly the following. if F18 is less than 100 then F24=100-F18 can anyone help with this because I entered =IFF18<100,"100-F18","0" and it didn't work and im about to pull my hair out
Excel Code Formula Help?
I need a excel formula that will allow you to enter a numerical value in one column and a letter in the a second column. The equation would make a 1 A = 1.1, 1 B = 1.2, 1 C= 1.3, 2 A = 2.1, 2 B = 2.2 and so on. Any thoughts?
I need help with excel formula?
I need help with excel formula. OT rate is 2x the amount of the normal rate but once 9 hours or greater are reached then 8 hours are 2x the amount the ninth and greater are 3x the amount of normal pay. hourly rate is $10.00 8.99 hrs over time get paid 179.80 (8.99x20.00) 9 hours OT get paid 8x20.00=160 plus 1x30.00=30.00 Total: 190.00 I need a formula that will show an amount up to 8.99 and if equal to or greater then 9 to show 8 and the rest in the next cell down if the original number is 9 like this example cell A2 should show 8 hours and cell A3 should show 1 hour If the original number is 6 then cell A2 should show 6 hours and cell A3 should show 0 hours is this possible? Actual rate is not 10.00. Simply used 10.00 for a simple example. In the image it may will show different numbers. OT starts after completing the 49th hour. First 48 hours are normal rate.