IF statement with formula
 

Hi,
Hope you can help me with this please.
I have an IF statement running on a group of cells. If the cells meet a
certain criteria the output is a formula that I wish the cell to compute. I
seem to have something wrong. Here is a simplified version, the real one
contains huge long formulas
IF(F4="CASE2", "=G1+100")
But I dont want the cell to print out G1+100 as it is doing now. I want it
to compute the formula. I have tried without the " " around the G1+100 oart
but no luck.
What am I missing??
Thank you in advance,
C

IF statement with formula
 

IF(F4="CASE2", G1+100)
--
- K Dales


"ladee_bird" wrote:

Hi,
Hope you can help me with this please.
I have an IF statement running on a group of cells. If the cells meet a
certain criteria the output is a formula that I wish the cell to compute. I
seem to have something wrong. Here is a simplified version, the real one
contains huge long formulas
IF(F4="CASE2", "=G1+100")
But I dont want the cell to print out G1+100 as it is doing now. I want it
to compute the formula. I have tried without the " " around the G1+100 oart
but no luck.
What am I missing??
Thank you in advance,
C

IF statement with formula
 

thanks that works!

"K Dales" wrote:

IF(F4="CASE2", G1+100)
--
- K Dales


"ladee_bird" wrote:

Hi,
Hope you can help me with this please.
I have an IF statement running on a group of cells. If the cells meet a
certain criteria the output is a formula that I wish the cell to compute. I
seem to have something wrong. Here is a simplified version, the real one
contains huge long formulas
IF(F4="CASE2", "=G1+100")
But I dont want the cell to print out G1+100 as it is doing now. I want it
to compute the formula. I have tried without the " " around the G1+100 oart
but no luck.
What am I missing??
Thank you in advance,
C