Copy Data from a Cell to another based 2 conditions

[Teffi]

Hello!

I can't seem to figure out how to accomplish the below 2 functions, is it even possible:

1.) If there is an "X" in D and a value in O, then copy value from O to R
2.) If there is a Value in R then auto-populate a "X" in AC; AC currently has a formula of

which populates AD and I still need that to happen if AC criteria is met.

Thank you in advance for any guidance.

 

[Greenbehindthecells]

Hello,

The formulas in AC2 reference's itself ( cell AC2)?

 

[Greenbehindthecells]

I am not sure I understand. If the formula listed as 2.) is in cell AC2, it will be a circular reference. From your screenshot, you have "Fair Market Value" in AD2, is it possible that the formula listed is in cell AD2? Try:

R2 =if(and(D2="x",O2="*"),O2,"")
AC2 =if(R2="*","x","") If the formula in AD2 is =if(isblank(AC2,"","Fair market value") it should still function.

 

[Greenbehindthecells]

Sorry for my mistype:
R2 = =IF(AND(D2="x",O2<>""),O2," ")
AC2 =IF(R2<>"","x","") If the formula in AD2 (from 2.) is =if(isblank(AC2,"","Fair market value") it should still function.

 

[Teffi]

Sorry for my mistype:
R2 = =IF(AND(D2="x",O2<>""),O2," ")
AC2 =IF(R2<>"","x","") If the formula in AD2 (from 2.) is =if(isblank(AC2,"","Fair market value") it should still function.

OMG!! Thank you that worked perfect!!!! And yes you were correct I did misspeak the Fair Market Value formula was in AD

 

[Greenbehindthecells]

OMG!! Thank you that worked perfect!!!! And yes you were correct I did misspeak the Fair Market Value formula was in AD

You are welcome. I'm glad this helped. Please mark the reply as resolved for the forum so this post will be marked as resolved . I hope you have a great day.