| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF-then formula doesn't work
I can't figure this one out...
=IF(M160,INDIRECT("V"&SUM(O2+1),0)) the INDIRECT("V"&SUM(O2+1) aspect worked fine, but I only wanted that value to show so I added the IF aspect... I keep getting errors in the value -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF-then formula doesn't work
You put a bracket in wrong place
here is the correction: =IF(M160,INDIRECT("V"&SUM(O2+1)),0) "pegman" wrote: I can't figure this one out... =IF(M160,INDIRECT("V"&SUM(O2+1),0)) the INDIRECT("V"&SUM(O2+1) aspect worked fine, but I only wanted that value to show so I added the IF aspect... I keep getting errors in the value -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF-then formula doesn't work
And you don't need the SUM as well as the + sign.
=IF(M160,INDIRECT("V"&(O2+1)),0) -- David Biddulph "Teethless mama" wrote in message ... You put a bracket in wrong place here is the correction: =IF(M160,INDIRECT("V"&SUM(O2+1)),0) "pegman" wrote: I can't figure this one out... =IF(M160,INDIRECT("V"&SUM(O2+1),0)) the INDIRECT("V"&SUM(O2+1) aspect worked fine, but I only wanted that value to show so I added the IF aspect... I keep getting errors in the value -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF-then formula doesn't work
The reason you got an error is because as written:
=IF(M160,INDIRECT("V"&SUM(O2+1),0)) Your formula is using the 0 in INDIRECT to denote that you're using R1C1 reference style. So, Vn is not a legitimate R1C1 reference so you get the error. -- Biff Microsoft Excel MVP "Teethless mama" wrote in message ... You put a bracket in wrong place here is the correction: =IF(M160,INDIRECT("V"&SUM(O2+1)),0) "pegman" wrote: I can't figure this one out... =IF(M160,INDIRECT("V"&SUM(O2+1),0)) the INDIRECT("V"&SUM(O2+1) aspect worked fine, but I only wanted that value to show so I added the IF aspect... I keep getting errors in the value -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF-then formula doesn't work
=IF(M160,INDIRECT("V"&SUM(O2+1)),0)
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pegman" wrote in message ... I can't figure this one out... =IF(M160,INDIRECT("V"&SUM(O2+1),0)) the INDIRECT("V"&SUM(O2+1) aspect worked fine, but I only wanted that value to show so I added the IF aspect... I keep getting errors in the value -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF-then formula doesn't work
Thanks guys, everything works beuatiful now...
I need to figure how to protect these worksheets NOW...!!!! -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! "pegman" wrote: I can't figure this one out... =IF(M160,INDIRECT("V"&SUM(O2+1),0)) the INDIRECT("V"&SUM(O2+1) aspect worked fine, but I only wanted that value to show so I added the IF aspect... I keep getting errors in the value -- I didn''''t go bald because of genetics, I''''m pulling them out one at a time! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF-then formula doesn't work
ToolsProtectionProtect Worksheet is the norm.
Gord Dibben MS Excel MVP On Sat, 5 Jan 2008 10:08:00 -0800, pegman wrote: Thanks guys, everything works beuatiful now... I need to figure how to protect these worksheets NOW...!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does this formula not work? | Excel Worksheet Functions | |||
| Why does this Formula work? | Excel Worksheet Functions | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| How do I get this formula to work? | Excel Discussion (Misc queries) | |||
| formula doesn't work | Excel Discussion (Misc queries) | |||
Hybrid Mode
