need help with a formule
I am working with excel (one of the first time I use excel :D) but
have a problem. I have this formula: =SOM(Q8*Instellingen!B16*Instellingen!Q3) But when you leave the field blank in Q8, you see in the field wher this formula is a - How do I change the formula to see nothing in that field??? (i hope you guys understand it a little bit -- Message posted from http://www.ExcelForum.com |
need help with a formule
Try something like
=IF(Q8="","",SUM(Q8*Insetllingen!B16*Instellingen! Q3)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "sebasjuh " wrote in message ... I am working with excel (one of the first time I use excel :D) but I have a problem. I have this formula: =SOM(Q8*Instellingen!B16*Instellingen!Q3) But when you leave the field blank in Q8, you see in the field where this formula is a - How do I change the formula to see nothing in that field??? (i hope you guys understand it a little bit) --- Message posted from http://www.ExcelForum.com/ |
need help with a formule
I tried this code
=IF(Q8="","",SUM(Q8*Instellingen!B16*Instellingen! Q3)) But I get a error and it says that the formula is not good. : -- Message posted from http://www.ExcelForum.com |
need help with a formule
do you have a regional setting that uses the semi colon (;) as the list
separator rather than the comma. If so, it should be: =IF(Q8="";"";SOM(Q8*Instellingen!B16*Instellingen! Q3)) or just =IF(Q8="";"";Q8*Instellingen!B16*Instellingen!Q3) -- Regards, Tom Ogilvy "sebasjuh " wrote in message ... I tried this code: =IF(Q8="","",SUM(Q8*Instellingen!B16*Instellingen! Q3)) But I get a error and it says that the formula is not good. :( --- Message posted from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 01:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com