| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
