Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation-problem
Hello,
I´m been trying to make a calculation but I can´t get it right. I don´t know the enlish word but in swedish its #värdefel! (value wrong). =OM($AC12="3";OM($Q12="01";(BR12+BT12+BV12);OM($Q1 2="02";(BR12+BT12+BV12);OM($Q12="03";(BR12+BT12+BV 12);"")));"") Are there any smart persons who can help me? MR Mia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation-problem
(BR12+BT12+BV12)
will return an error if any of the cells contain Text. Sum(BR12,BT12,BV12) would be more robust. -- Regards, Tom Ogilvy "Mia" wrote: Hello, I´m been trying to make a calculation but I can´t get it right. I don´t know the enlish word but in swedish its #värdefel! (value wrong). =OM($AC12="3";OM($Q12="01";(BR12+BT12+BV12);OM($Q1 2="02";(BR12+BT12+BV12);OM($Q12="03";(BR12+BT12+BV 12);"")));"") Are there any smart persons who can help me? MR Mia |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation-problem
(BR12+BT12+BV12)
is not text it´s figures. // Mia "Tom Ogilvy" skrev: (BR12+BT12+BV12) will return an error if any of the cells contain Text. Sum(BR12,BT12,BV12) would be more robust. -- Regards, Tom Ogilvy "Mia" wrote: Hello, I´m been trying to make a calculation but I can´t get it right. I don´t know the enlish word but in swedish its #värdefel! (value wrong). =OM($AC12="3";OM($Q12="01";(BR12+BT12+BV12);OM($Q1 2="02";(BR12+BT12+BV12);OM($Q12="03";(BR12+BT12+BV 12);"")));"") Are there any smart persons who can help me? MR Mia |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation-problem
Did you test it. For example, a 2 in a cell could be stored as the number 2
or it could be stored as the letter 2. Then again, maybe you are not having any problems. -- Regards, Tom Ogilvy "Mia" wrote: (BR12+BT12+BV12) is not text it´s figures. // Mia "Tom Ogilvy" skrev: (BR12+BT12+BV12) will return an error if any of the cells contain Text. Sum(BR12,BT12,BV12) would be more robust. -- Regards, Tom Ogilvy "Mia" wrote: Hello, I´m been trying to make a calculation but I can´t get it right. I don´t know the enlish word but in swedish its #värdefel! (value wrong). =OM($AC12="3";OM($Q12="01";(BR12+BT12+BV12);OM($Q1 2="02";(BR12+BT12+BV12);OM($Q12="03";(BR12+BT12+BV 12);"")));"") Are there any smart persons who can help me? MR Mia |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation-problem
Thank you!
I made following change in the BT12-cell from =OM($Q12="01";$AF12*((Dataunderlag!$H$13-$U12+1)/Dataunderlag!$H$13);"") to =OM($Q12="01";$AF12*((Dataunderlag!$H$13-$U12+1)/Dataunderlag!$H$13);"0") So everything works, thanks! // Mia "Tom Ogilvy" skrev: Did you test it. For example, a 2 in a cell could be stored as the number 2 or it could be stored as the letter 2. Then again, maybe you are not having any problems. -- Regards, Tom Ogilvy "Mia" wrote: (BR12+BT12+BV12) is not text it´s figures. // Mia "Tom Ogilvy" skrev: (BR12+BT12+BV12) will return an error if any of the cells contain Text. Sum(BR12,BT12,BV12) would be more robust. -- Regards, Tom Ogilvy "Mia" wrote: Hello, I´m been trying to make a calculation but I can´t get it right. I don´t know the enlish word but in swedish its #värdefel! (value wrong). =OM($AC12="3";OM($Q12="01";(BR12+BT12+BV12);OM($Q1 2="02";(BR12+BT12+BV12);OM($Q12="03";(BR12+BT12+BV 12);"")));"") Are there any smart persons who can help me? MR Mia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculation problem... | Excel Programming | |||
FV Calculation problem | Excel Worksheet Functions | |||
Calculation problem - please help | Excel Discussion (Misc queries) | |||
calculation problem | Excel Discussion (Misc queries) | |||
Calculation Problem | Excel Discussion (Misc queries) |