I need to check 3 cells if they have a value meaning if they are not empty or have 0. Then I need to multiply 11.1 by number of cells that have value. e.g if two of the three cells have a value then the result cell should be 11.1 * 2 = 22.2. if only one cell has a value the result should be 11.1 and if none of the three cells is empty or zero the result should be 33.3.
Thank you.
I did not try anything as I am new to excel
New contributor
1