| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISTEXT() function problem
=IF(ISTEXT(c3),FALSE,Sum(f1:f20),TRUE)
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISTEXT() function problem
Too many arguments for the IF function
If you explain what you are trying to do, maybe someone could provide more assistance. --JP On Nov 20, 9:26 am, Finance Guru wrote: =IF(ISTEXT(c3),FALSE,Sum(f1:f20),TRUE) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISTEXT() function problem
Sorry people - an error am posting the full problem
"Finance Guru" wrote: =IF(ISTEXT(c3),FALSE,Sum(f1:f20),TRUE) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISTEXT() function problem
-JP you were too quick for me - in the maentime i have posted the full problem
"JP" wrote: Too many arguments for the IF function If you explain what you are trying to do, maybe someone could provide more assistance. --JP On Nov 20, 9:26 am, Finance Guru wrote: =IF(ISTEXT(c3),FALSE,Sum(f1:f20),TRUE) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If + ISTEXT + SEARCH | Excel Discussion (Misc queries) | |||
| IF-ISTEXT formula | Excel Discussion (Misc queries) | |||
| Using ISTEXT across separate Spreadsheets | Excel Worksheet Functions | |||
| ISTEXT | Excel Discussion (Misc queries) | |||
| I need help with a =sum IF ISTEXT formula. I keep getting 0. | Excel Discussion (Misc queries) | |||
Linear Mode
