LEN function

[LauraForiero]

I have a Slogan column and now i need to create a Slogan cost column, how would i write this function if

the 1st 30 characters are charged $15.00 per letter including spaces, for each letter over 30 the charge is $10.00

using the LEN function?


Thank you

[judgeh59]

does this work?

Please Login or Register  to view this content.

[martindwilson]

=min(len(a1),30)*15+max(len(a1)-30,0)*10

[AlKey]

Or this:

=SUM(IF(LEN(A1)>30,LEN(A1)-30)*10,LEN(A1)*15)

[VKS]

Interesting, first 30 are characters and after that each letter…. What about space after 30 characters?
Regards/VKS

[AlKey]

Interesting, first 30 are characters and after that each letter…. What about space after 30 characters?
Regards/VKS

Per OPs requirements "the 1st 30 characters are charged $15.00 per letter including spaces"