LinkBack URL
About LinkBacks
This “IF” example formula on cell A1
=if(D5=”1”,”10”,””)
Will return 10 if D5 has 1… is it possible to have the formula in another cell but still return the value in cell A1???
This “IF” example formula on cell A1
=if(D5=”1”,”10”,””)
Will return 10 if D5 has 1… is it possible to have the formula in another cell but still return the value in cell A1???
oh, may be
=IF(D5=1,10,"")
and another cell?
I couldn't catch your point
well I want the formula to be in cell let's say L10 but return the value to A1.....
No, it's not possible to have a formula in one cell return its result to another, other than to simply put a formula in A1 to reflect that cell's value.
But there's no reason not to simply put your function IN cell A1 since that's where you want the see the result.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
It sound strange,Originally Posted by jgomez
You try
at A1: =L10
at L10: =IF(D5=1,10,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks