Aug 06 2021 07:27 AM
Aug 06 2021 11:38 AM
Well, one thing that is true is that your request needs to provide more information--quite a bit--before anybody can jump to help.
If possible, if you have a spreadsheet you're working on, please attach it. But please, too, a more complete description of the context in which this "If true, then jump" action is desired. What is the whole project about, and how does your request fit into it?
Those are the kinds of questions we would start with if I were sitting down with you face to face; it always makes more sense to get the big picture before focusing on a detail.
Aug 06 2021 02:12 PM
the formula i'm using is follows
B6 = 12
If(b4=<550,if(b6<,"go to" a29,0))
Aug 06 2021 02:39 PM
As I said before, can you give a more complete picture of what you're trying to do (big picture), not just restating what you've said in different words. What's the context in which this is supposed to happen? And attach the spreadsheet.
I've never seen a "go to" function. Macros could be written, I'm sure.... but that's getting ahead of ourselves.
As for the formula you've written:
b4=<550, good so far; that's a valid comparison
if(b6<, if b6 is less than [???] no comparison there
"go to" a29, as noted, there is no "go to" function or command outside of a macro
0)) where is this formula written that the value 0 should go if neither condition is met?
Sadly your syntax is wrong to begin with, so this formula will not work. And I don't know what you're trying to do so have no suggestion for repair.
Aug 11 2021 02:32 PM
I am trying to do a test i.e. data in location b4 is true then I want to do additional calculations in another area oy the spreadsheet but if false I want to give "false"
I am unable to give you more information be I signed an non discloser agreement
Aug 11 2021 05:24 PM
You wrote: I am unable to give you more information be I signed an non discloser agreement
OK, I can respect that and fully expect you to honor that, but the non-disclosure agreement surely doesn't preclude setting up and sharing a dummy spreadsheet with a mockup of the circumstances or relationships that reveals none of the specifics but all of the logical difficulties that have stymied you. Your descriptions are just vague enough that it makes it difficult to offer any specific advice or suggestions.