Ton,

By having a FALSE return (ie the "Nothing"), for the first IF statement that
makes that IF complete. Assuming that you want the calculation for 9 or
under, "Nothing" for 10 and "Help" for 11 or more then try:

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

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"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