Logical values help required

[kamalthakur]

Dear All,

Please help me out with below query

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

[Tiresidedown]

Kamalthakur,

I can't understand your question. I'll help if I can understand it.

Dan

[kamalthakur]

I mean to say that If I enter value in any data column as 1 the first condition is it has to perform calulation (mentioned in spreadsheet)
Second condition is apart from the cell where we have value as 1 for all other data columns the value should become 0 same as for months column