ExcelBanter - Data validation formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data validation formula (https://www.excelbanter.com/excel-worksheet-functions/119996-data-validation-formula.html)

Pasty

Data validation formula

Does anyone know why this Data Validation formula will work in a new
spreadsheet but if I put it into my risk register it won't.

=IF($O$2=$P$2,$AU$2:$AU$3,0)

Are there certain things I should be looking for or common mistakes?

driller

Data validation formula

"=IF($O$2=$P$2,$AU$2:$AU$3,0)"

what is the true result "$AU$2:$AU$3", is it sum(), count(), max(), min(),
average(), etc.. ? please specify.

"Pasty" wrote:

Does anyone know why this Data Validation formula will work in a new
spreadsheet but if I put it into my risk register it won't.

=IF($O$2=$P$2,$AU$2:$AU$3,0)

Are there certain things I should be looking for or common mistakes?

All times are GMT +1. The time now is 12:08 AM.