Query on data input

[kamalthakur]

Hi All,

I Have a query for which I have attached the sample sreadsheet

My query is

This spreadsheet has Data columns and Month Columns
Data columns has conditional formatting
Value to input is 1 data

Help Required
If I enter 1 in any of the data column then it should do the calculation for consecutive month as below
Example If 1 enter 1 in Data 1 column then it should perform the action for Month 1 as =C2*b2*a2 and display the result 3%

Once the calculation is done then all the other data columns should become 0 and the consecutive months should become 0
The same Data column value and month column value has to be displayed in Total and output columns

Total column is for Data and output column is for Month values

Condition is I may enter 1 in any of the data column then all the data columns and month columns should become 0