G
Guest
The following is an if-function i am trying to get working but it doesnt
accept it and shows me if the cell [7_Evaluaciones_Auditoriias_cuentas]![11]
equals to 5 it gives in the cell for 'Ãndice máximo 1' an #Error-message
(instead of doing the calculation of 5*10) and if i put nothing (it should
put a zero) it calculates 5*10. I just don't understand, it doesnt do what it
should at all!
The if-Function: Ãndice máximo 1:
IIf([7_Evaluaciones_Auditoriias_cuentas]![11]="";0;5*10)
Please can someone help me with this as it seemed so simple but it just wont
do.
accept it and shows me if the cell [7_Evaluaciones_Auditoriias_cuentas]![11]
equals to 5 it gives in the cell for 'Ãndice máximo 1' an #Error-message
(instead of doing the calculation of 5*10) and if i put nothing (it should
put a zero) it calculates 5*10. I just don't understand, it doesnt do what it
should at all!
The if-Function: Ãndice máximo 1:
IIf([7_Evaluaciones_Auditoriias_cuentas]![11]="";0;5*10)
Please can someone help me with this as it seemed so simple but it just wont
do.