0

I'm having a bit of trouble figuring out the calculation in a calculated column. Here's what I've got - I have two NUMBER columns (column A and Column B). What I want is to calculate "Column A is ?? Percent of Column B?" What would my calculation be?

1 Answer 1

1

Use the formula given below.

=IF(ISERROR(ColumnA/ColumnB),"",ColumnA/ColumnB)

Result is shown in the image below (here percentage is - column1 is percent of Column2 shown in PercentColumn)

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.