A formula

[emvella]

Hi, Please I want a formula for this excel sheet:

https://drive.google.com/open?id=1uEnW5zXiEW6cYLrFqew8S8soTvsCruej

If possible I want to know the exact numbers in all empty cells from H5 to H79, I5 to I79 and J5 to J79.

Thanks in advance.

 

[Fluff]

If the cells are empty then there are no numbers to report. Can you please clarify what you need?

 

[emvella]

Hi Fluff,

Example in Column G I have angles from 0 to 75. But in columns H, I and J, I have only answers for angle 0, 15, 30, 45 and 60. Example angle 0 the three answers are the same 1.00. So, if I want to know the answer of angle 8 (or all other angles) I have to work a sum each time. What I want is that I will have the excel sheet with all answers.

 

[Fluff]

I'm sorry, but I still do not understand what you are asking for.

 

[emvella]

have you downloaded the excel file from here?
https://drive.google.com/open?id=1uE...w8S8soTvsCruej

 

[Fluff]

I have not downloaded it, because it does not tell me anything at all.
It just has some numbers in, which mean nothing to me. Where do those numbers come from? If you want to know the values for Angle 8, how do you calculate them?

 

[Fluff]

Cross posted https://www.msofficeforums.com/excel/43392-formula-excel-sheet.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.