If
 

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

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

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

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