IF formulas

[racinjason1978]

Hey Everyone,

I have searched through the forum and even watched on line videos...i don't have much experience in Excel either...

can someone explain to me why this won't work...?

=IF(A11="Completed",L11=J11,"0")

I have the formula located in L11. I read a little bit about circle referencing. What i am trying to do is add hours only when a job is completed. I have a list in A1 that has job statuses like Ready, InProgress, Blocked, and Completed. I got the formula working when i put "yes" in the true statement and "no" in the false but i was hoping to duplicate a number over to another column.

any thoughts??

Thanks in advance

[darkyam]

A formula can't refer to itself; it's called a circular reference. Replace L11=J11 with just J11. Also, you don't need quotes around the 0.

[NBVC]

The L11=J11 is what's causing the problem... If you put the formula in L11 then you implicitly state the at it should equal the result...if that makes sense

Also, the 0 should not be in quotes if you actually want the number 0 and not a text string.

anyways formula should be:

=IF(A11="Completed",J11,0)

[racinjason1978]

Thank you both...it worked

I am a noob to Excel so don't be surprised if you see alot of threads with my name on them...i have been trying to search but don't always understand what the context is in that particular situation...

also any idea why this forum logs ppl out so fast...seems like every 2 mins i have to log in again???