Thread: If
View Single Post
  #2   Report Post  
KL
 
Posts: n/a
Default

How about:

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

Regards,
KL


"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