Nested IF Function Errors - Help! ASAP

[Vilac7]

Hi All,

I'm doing a nested IF function but keep getting "you have entered too many arguments for this function". So my cell says #VALUE. Please help.

=IF(D2>25,"Link Text is too Long. 25 Characters max.","No errors found"),(IF(E2>35,"Description Line 1 is too Long. 35 Characters max.","No errors found"))

Warm regards,
Vilac

[sandy666]

try
wrong formula: see Ford #4 post if in cells hes a numbers
or
=IF(LEN(D2)>25,"Link Text is too Long. 25 Characters max.",IF(LEN(E2)>35,"Description Line 1 is too Long. 35 Characters max.","No errors found"))

[TMS]

Deleted. Formula incorrect.

[FDibbins]

Try this...
=IF(E2>35,"Description Line 1 is too Long. 35 Characters max.",if(D2>25,"Link Text is too Long. 25 Characters max.","No errors found"))

edit: by putting the > 25 part 1st, that will always trigger, even if the value is > 35

[sandy666]

@Ford

correct as usual