Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
On the celd show a formule not its value, why?? | Excel Discussion (Misc queries) | |||
time formule | Excel Discussion (Misc queries) | |||
formule | Excel Programming | |||
Itratie formule | Excel Programming | |||
HOW to show in A2 the formule used in A1 ? | Excel Programming |