View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Jianguo Li Jianguo Li is offline
external usenet poster
 
Posts: 5
Default Nested IF function (simple)

The error may caused by cell format.
If I can see the workbook file, I may find out what's wrong actually.

"TeKouma" дÈëÏûÏ¢
...

Cannot put "=e2+if("....

I have.... =IF(L2=12.72,E2+35,IF(L2=17.47,E2+50)

Anyone?




--
TeKouma