LinkBack URL
About LinkBacks
Is it possible to use cell references in an IF function's logical test?
Like:
C1: M2=""
D1: O2
if(c1;d1;1)
Because if I use it that way then the expression is used as a text ("M2=""") hence it doesn't work.
Is it possible to use cell references in an IF function's logical test?
Like:
C1: M2=""
D1: O2
if(c1;d1;1)
Because if I use it that way then the expression is used as a text ("M2=""") hence it doesn't work.
Something like this......
Formula:
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
I get the #ref error with indirect
I believe either C3 or D3 will be blank without valid cell reference. Please explain what you are trying to do?
I'am trying to simplify an IF function for other users so they will not have to dig inside the IF function, just change the values outside.
Something like this
=IF(C1;D1;IF(C2;D2;IF(C3;D3;IF(C4;D4..and so on..)
And all the expressions are listed in the C(logical test) and D(true) columns
C1: M1=""
D1: O1
C2: LEFT(M2;1)="1"
D2: O2
etc..
So the expressions and all the stuff which would normally be in the IF function are used as a reference and listed outside the function.
The way which you are trying to do is something going to be a cumbersome approach rather than just building it inside the IF function
The users can't change the IF function they get lost in it (that's what they say). Do you have any other idea? or a different approach to solve this problem?
What do the users need to change in the formula?
If posting code please use code tags, see here.
basically whatever they wantevery condition should be flexible so they can change them
Edit: The only thing that is constant is the IF function's structure
Thanks Norie for relieving me from this thread
I was scared, since evaluating formula mentioned as text value in a cell OR conditions in the same way is not the easy one
I uploaded a sample. It basically look like this
default.xlsx
anybody got any solutions or ideas?
I looked at your file and, sorry, it makes no sense to me. you will have to explain exactly what you are trying to do, and give a few examples of what you expect answers to look like, as well as how you arrived at them
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It's probably possible using one of the techniques described
here:http://www.myonlinetraininghub.com/e...luate-function
or
here:http://www.pcmag.com/article2/0,2817,2212496,00.asp
both would require macros enabled, and a change of your formula to something like this:
Formula:Please Login or Register to view this content.
to change your formula into a string either method could work on, the real question is , is it worth the hassle?
if end users know enough to change the conditions, they should be able to do it in the formula, if not, you are going to be answering/fixing it all the time anyways..
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Thanks to FDibbins & dredwolf for getting pitched IN for sharing your valuable suggestions
@ dredwolf,
Thanks for showing the light for the OP on the way the OP wanted to move on
sorry I couldnt help more, but at least (i hope) a solution was arrived at
I just remembered seeing something pretty similar in the forum was all
@ Sixthsense
Thanks for the kind words
Edit-
Still can not find that thread though
Thank you for your help guys, I'll take a look at it and see if it works.
@dredwolf
I have to do it. I know it is nonsense but it has to be done.
Well, Good luck, and I hope it doesn't become too big a problem !
here is a sample of what I think you want
Josie
if at first you don't succeed try doing it the way your wife told you to
Thank you JosephP. I wanted to do the exact same thing. How could I do this on an other sheet? If the data is on an other sheet (B,M,Q,O column)Originally Posted by JosephP
So I want to drag it down and fill the S column (on Sheet2!) so it evaluates all rows.
I couldn't upload it for some reason so I uploaded it on GoogleDocs:
HTML Code:
that will be ridiculously complex to set up and incredibly inefficient in use so I really can't recommend using it.
Ok. Understood, thank for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks