If you are using French Excel you use ; if you use English Excel use , (coma
to separate the arguments).
The following formula works for me in English

=IF(C11<=9,(10-C11)*47/100*1000,IF(C11=11,"help","nothing"))


Gilles

"Ton@Home" wrote in message
...

What i do here wrong, its not working.


=IF(C7<=9;(10-C7)*47/100*1000;"Nothing";IF(C7=11;"HELP"))


=IF(C7<=9;(10-C7)*47/100*1000;"Nothing") <-- this is working.


Help

Ton


--
Ton@Home
------------------------------------------------------------------------
Ton@Home's Profile: http://www.msusenet.com/member.php?userid=5033
View this thread: http://www.msusenet.com/t-1871048095