I'm inserting a formula where i need to calculate certain % of a value in columns.
The value is correctly getting picked but where I'm stuck is that the same value is getting spread in all the columns horizontally and vertically. I need that value only in particular cell. Either help me with the formula or is there anyway to hide cell values of a row/column?
I'm attaching image for the reference.
Thank Yo