Question:
Hi,
Can someone tell me how do i apply formula on a specific cell only ?
Here's what i want to do:
Rows: Gross Sales, Net Sales
Columns: A, B
Only apply the following formula on Net Sales X Column A.
If Row = Net Sales And Column = A then
Result = Result * 0.5
endif
How do i do the above ?
Answer:
Make sure both your rows and columns have a structure (right-click, new structure). After this, a previously greyed-out button called 'cell editor' will be available in the toolbar.