Hi,

Am Fri, 24 Jun 2016 16:55:59 +0100 schrieb DUV:

=IF(AND(A1*0.15%<=350),350,IF(AND(A1*0.15%350,A1* 0.15%<1500),A1*0.15%,IF(AND(A1*0.15%=1500),1500)) )

try:
=MAX(MIN(A1*0.15%,1500),350)


Regards
Claus B.

Wizard!!!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus