| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula If statement. | Excel Worksheet Functions | |||
| if statement in formula | Excel Discussion (Misc queries) | |||
| Need help with if-then statement in formula | Excel Discussion (Misc queries) | |||
| Can I use IF statement with a formula? | Excel Worksheet Functions | |||
| If statement or another formula help | Excel Programming | |||
Linear Mode
