How Do You Use Pi in Excel Formulas?
I Am Trying to Write an Equation in Excel but I Keep Getting #Name? in the Cell. I Think It Is Related to the Use of Pi but Am Not Sure Since the Rest Is Just...
I am trying to write an equation in Excel but I keep getting #NAME? in the cell.
I think it is related to the use of PI but am not sure since the rest is just numbers or cell references.
This is what I wrote in my formula:
= ( 4 * (pi) * A2^2 * 5.671*10^(-8) * (B2)^4 )
I applied it to each row and every row gives the same #NAME? output. It's not clear what i am getting wrong. Hope someone can help explain what I am doing wrong.
One thing I notice is it keeps making PI lowercase, why though?
1 Answer
PI is a function and not a variable or cell name so it must be called with ()
=4 * PI() * A2^2 * 5.671*10^(-8) * (B2)^4
Sarah Jenkins is a veteran tech journalist with over 12 years of experience covering artificial intelligence, mobile innovations, and digital ethics. Her insights have appeared in leading technology publications worldwide.
