Calculating accuracy within excel

0 votes

In MS Excel, I have three cells: a Prediction cell (A1), Results cell (B1), and Difference cell (C1). I have a cell called Accuracy (D1) where I would like to display the accuracy of the prediction made in light of the outcome.

As an illustration, if I forecast 24 and get 24, the accuracy should be 100% with a difference of 0. The accuracy should be 50% with a differential of -12 if I have a prediction of 24 and an outcome of 12. The accuracy should be 50% with a differential of 12 if I have a prediction of 24 and an outcome of 48.

Here is the calculation I'm using in the Accuracy cell (D1):

=(((C1+100)*A1)/B1)/(C1+100)

This calculation is only showing the expected results when the Prediction cell is higher than or equal to the Results cell.

Dec 22, 2022 in Others by Kithuzzz
• 28,700 points
106 views

1 answer to this question.

0 votes

Format the cell in Col C as "%" and then try this formula:

The formula in C1 as per the snapshot:

=IF(B1<A1,VALUE("-"&(B1/A1)),(B1/A1))

The formula in D1 as per the snapshot:

=B1-A1

Various test scenarios are below.

enter image description here

answered Dec 23, 2022 by narikkadan
• 53,160 points

Related Questions In Others

0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
294 views
0 votes
1 answer

Excel calculating drop rates

Each column's "total" row is just the ...READ MORE

answered Oct 29, 2022 in Others by narikkadan
• 53,160 points
84 views
0 votes
1 answer

Frequency Array formula EXCEL not calculating

You obtain the same outcome, which suggests ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 53,160 points
57 views
0 votes
0 answers

Why is Excel not calculating the cube root as the cube root?

I think Excel treats exponents with recurring ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 28,700 points
48 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
213 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
386 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,630 points
175 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 22,940 points
162 views
0 votes
1 answer

Excel formula to check date within this week and last week

Assuming the first date in A2 try this formula ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
• 53,160 points
175 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP