can I use circular Refference to get Desired Output?

**gujjar** · 08-22-2008, 09:20 AM

Any help is appreciated.

I want to use sort of a formula or conditional formatting formula to get different outputs.

If I type a "Yes" in cell A1, It should become 2
and similarly if i put "No" in cell A1, It should become 2.5

Is it possible? without VBA

Please suggest all possible ways which could be used to get desired results, except for VBA. Because I'm a novicexcel.

Best Regards

**NBVC** · 08-22-2008, 09:37 AM

Without VBA...not possible....

You can use the adjacent cells, though with a small formula...

e.g. in B1 enter =If(A1="Yes",2,if(A1="No",2.5,""))

**gujjar** · 08-22-2008, 09:49 AM

NBVC Thanks for the help.
Actually I have a very big table to work with. I mulled over it alot and thought it might possible to do it with circular refference.

I'll use the method you've suggested. Could you pls elaborate the circular refference via small example. I have yet to learn it.

Best Regards