If

T

Ton@Home

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

To
 
G

Gilles Desjardins

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
 
S

Sandy Mann

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
[email protected]
Replace@mailinator with @tiscali.co.uk
 
Top