I only want to populate 5 in the calculated field if the balance is greater than 300 and less than 1000. Is it only populating if any of the fields fall below 300. Any suggestions?

=IF(OR( (D14:V14>300) * (D14:V14<1000)),5,0)

1,905.01463.08380.56367.43367.43268.21223.2223.2170.52661.12643.04584.23584.23508.32330.47310.65300.65214.75683.08

​I only want to populate 5 in the calculated field if the balance is greater than 300 and less than 1000. Is it only populating if any of the fields fall below 300. Any suggestions?=IF(OR( (D14:V14>300) * (D14:V14<1000)),5,0)1,905.01463.08380.56367.43367.43268.21223.2223.2170.52661.12643.04584.23584.23508.32330.47310.65300.65214.75683.08  Read More

​