IF Function

M

Mike

You were probably getting a #Name? error the first time
right? That's because you should have put quotes around
the Y.
=IF(Analysis!G2="Y",Analysis!B2,"")

A circular reference occurs when the formula in a cell
refers to that cell. You probably copied =IF(Analysis!
G2=Y,Analysis!B2,"") to Analysis!G2 right?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2
VB Function for Copy & Paste 0
sumif in a template 1
Logical Function 1
I have a very specific question about excel, please help! 1
VLOOKUP ? 16
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Mix/Max/Avg Help based on dynamic ranges 16

Top