IF a cell = specific text, then do this, if it = diff specific text then do this

[drop05]

Hello I have this formula i needed to edit since i made some changes to my excel sheet
This is my original formula

=OFFSET('Sheet H'!$A$32,0,((((COLUMN(D26)-4)/16)+1)*4))

I am looking to add some logic to the formula that references if a cell is equal it does a certain action,
So i am trying to add that If cell E17 is equal to "Passive" then do the original =OFFSET('Sheet H'!$A$32,0,((((COLUMN(D26)-4)/16)+1)*4))

but if E17 is equal to "General" do the same logic but reference $A$31 rather than $A$31 so =OFFSET('Sheet H'!$A$31,0,((((COLUMN(D26)-4)/16)+1)*4))

all in one formula, if this is possible

 

[jtakw]

Hi,

Try this:

=OFFSET(IF(E17="Passive",'Sheet H'!$A$32,'Sheet H'!$A$31),0,((((COLUMN(D26)-4)/16)+1)*4))

 

[drop05]

Hi,

Try this:

=OFFSET(IF(E17="Passive",'Sheet H'!$A$32,'Sheet H'!$A$31),0,((((COLUMN(D26)-4)/16)+1)*4))

This does work but i am trying to add logic that if the cell E17 is "General" then it would do $A$32

 

[jtakw]

So i am trying to add that If cell E17 is equal to "Passive" then do the original =OFFSET('Sheet H'!$A$32,0,((((COLUMN(D26)-4)/16)+1)*4))

but if E17s equal to "General" do the same logic but reference $A$31 rather than $A$31 so =OFFSET('Sheet H'!$A$31,0,((((COLUMN(D26)-4)/16)+1)*4))

all in one formula, if this is possible

This does work but i am trying to add logic that if the cell E17 is "General" then it would do $A$32

That's exactly the Opposite of what you said in OP, see Bold, Underlined, Red above.

So which way is the correct way ???

 

[drop05]

That's exactly the Opposite of what you said in OP, see Bold, Underlined, Red above.

So which way is the correct way ???

My apologize fat fingered the 2

so i was thinking like a double if in the formula similar to how you had it

=OFFSET(IF(E17="Passive",'Sheet H'!$A$32,'Sheet H'!$A$31),0,((((COLUMN(D26)-4)/16)+1)*4))

=(IF(E17="Passive",(OFFSET('Sheet H'!$A$32,0,((((COLUMN(D26)-4)/16)+1)*4))),"")
=IF(E17="General",(OFFSET('Sheet H'!$A$31,0,((((COLUMN(D26)-4)/16)+1)*4))),""))

a way to combined them together
but also my apologize i read the formula wrong that you put and was thinking if it needed the "General" text added to it.

however when E17 is blank, it is giving me the value of when passive is there, is there something to add to make the cell have no value if neither passive or general is selected?

 

[jtakw]

Then this should do it, if E17 is blank, results Blank, if "Passive", use A32, otherwise, use A31.

=IF(E17="","",OFFSET(IF(E17="Passive",'Sheet H'!$A$32,'Sheet H'!$A$31),0,((((COLUMN(D26)-4)/16)+1)*4)))

NOTE: let me know if it's Also possible to have words Other than "Passive" or "General", (e.g. "Unknown", "Maybe", etc.)