|
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 10:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com