Explain a formula?

[shonu1320]

Can somebody explain what this formula is doing?

=IF(LEN(E16)>0,IF(E16>(E13*(VLOOKUP($B$3,Data!B:DS,120,0)/260)),E16-(E13*(VLOOKUP($B$3,Data!B:DS,120,0)/260)),"NO"),"")

 

[Andrew Poulsom]

Any particular bit you don't understand? If E16 is blank the formula returns null. If E16 is less than or equal to (E13*lookup_value/260) it returns NO. Otherwise it returns E16 less (E13*lookup_value/260).

 

[shonu1320]

I just did not know what LEN function does?

 

[Andrew Poulsom]

It returns the length of its argument. If it's greater than zero it's not null.

 

[T. Valko]

I just did not know what LEN function does?

It's probably being used to make sure there is an entry in the cell.

However, that's not a very good method to use. You should check that the cell actually contains a number like this..

=IF(COUNT(E16),...

Or

=IF(ISNUMBER(E16),...

 

[shonu1320]

Got it! You are too good
Thanks again for helping me out today