 # Get instant live expert help on I need help with locally weighted regression “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

I need a formula as follows: IF B6 says "Can it be repurposed" AND G6 says "Yes", true="Do we have usage rights?", false value = "Can it be created locally?" However IF B6 says "Can it be created locally?" and B6 says "Yes", true="What is the timeframe", false = "No support available" I have tried the following, but it returns the error "Too many arguments" =IF(AND(B6="Can it be repurposed?",G6="Yes"), "Do we have usage rights", "Can it be created locally?", IF(AND(B6="Can it be created locally?",G6="Yes"), "What is the timeframe", "No support Available ")) Essentially I need two IF,AND statements in one formula
Solved by K. F. in 27 mins
I'm trying to determine the weighted average
Solved by Z. C. in 20 mins
I need help creating a formula. Consist of 3 data points. 2 are weighted 35% and 1 is weighted 30%. The 2 weighted at 35% the value can range from 0% to 100%. The 1 weighted 30% the value range is 0%-11% but the lower the number the better. Example 0%=100% of the 30%weighted, if that makes sense.
Solved by K. J. in 24 mins
I have a problem regarding to Weighted average
Solved by X. J. in 30 mins
I am looking for a way to weight baseball statistics - ex, batting average weighted by times at bat, earned run average weighted by innings pitched.
Solved by F. J. in 23 mins