Citação de Kindrazki em 25 de junho de 2012, 12:21Caso você esteja realizando operações de divisão por linha
ex. B1/A1, B2/A2, ...
É possivel que algum valor da coluna A (no exemplo) seja zero, então para adicionar um valor padrão no lugar do erro padrão do excel, usar a seguinte sintaxe:[code]
$[if(A1=0,0,B1/A1)]
[/code]
Caso você esteja realizando operações de divisão por linha
ex. B1/A1, B2/A2, ...
É possivel que algum valor da coluna A (no exemplo) seja zero, então para adicionar um valor padrão no lugar do erro padrão do excel, usar a seguinte sintaxe:
[code]
$[if(A1=0,0,B1/A1)]
[/code]
| Cookie | Duração | Descrição |
|---|---|---|
| cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
| cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
| cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
| cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
| cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
| viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |
