Generating results in another cell

[ap5]

Hi, I need help creating a formula to give me a number result after I put in a number in another cell.

- Column A Column B Column C

1 Apples --(?)-- % (input % amt will generate # amt for column B)
2 Oranges --(?)-- %
3 Bananas --(?)-- %

Total = sum of Column B
Total fruit = 50 = sum of Column B

So if I input a % in Column C, Column B will generate a number. The sum of Column B will equal the total number of fruits which is 50. I assume the formula will be in Column B but it will be blank until a number is placed in Column C.

Please let me know if there needs to be an clarification. Thanks in advance.

 

[jberwald]

Welcome to the board.

Try this in Column B:

=if(C1=0,"",50*C1)

 

[ap5]

Exactly what I needed, thanks jberwald!