ExcelBanter - if fuction in data validation

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - if fuction in data validation (https://www.excelbanter.com/excel-programming/417619-if-fuction-data-validation.html)

Sliman

if fuction in data validation

I need to limit data validation based on value in cell refrance.
if(a1="Multi",b20,sumif(F:F,c2,H:H)=b2)

if a1="Multi" then any positive value including 0
if a1 not ="Multi" then sumif formular

joel

if fuction in data validation

In data validation select Custom.

"Sliman" wrote:

I need to limit data validation based on value in cell refrance.
if(a1="Multi",b20,sumif(F:F,c2,H:H)=b2)

if a1="Multi" then any positive value including 0
if a1 not ="Multi" then sumif formular

All times are GMT +1. The time now is 11:50 PM.