ExcelBanter - ISTEXT() function problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - ISTEXT() function problem (https://www.excelbanter.com/excel-worksheet-functions/166780-istext-function-problem.html)

Finance Guru

ISTEXT() function problem

=IF(ISTEXT(c3),FALSE,Sum(f1:f20),TRUE)

JP[_3_]

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)

Finance Guru

ISTEXT() function problem

Sorry people - an error am posting the full problem

"Finance Guru" wrote:

=IF(ISTEXT(c3),FALSE,Sum(f1:f20),TRUE)

Finance Guru

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)

All times are GMT +1. The time now is 09:55 AM.