Excel formula/function help

[sejavogel]

Hi 

I am trying to write the formula =IF(D4:D11>=3,"Contact Procurement Services"," ") however it is not working. 

I have changed this to =IF(D4>=3,"Contact Procurment Services",IF(D5>=3,"Contact Procurement Services",IF(D6>=3,"Contact Procurement Services",IF(D7>=3,"Contact Procurement Services", IF(D8>=3,"Contact Procurement Services",IF(D9>=3,"Contact Procurement Services",IF(D10>=3,"Contact Procurement Services",IF(D11>=3,"Contact Procurement Services"" ")))))))) 

which works, except when the cells show less than 3 it says FALSE. 

Cells D4 to D11 are currently determined by a dropdown menu in C ( giving values from 1 to 5 depending on answer). 

Anyone have any idea how to fix this? 

Thank you

Seja 

[#2]

Seja,

it is not clear what do you want to fix.

A simple version of your formula would be:

=IF(COUNTIFS(D4:D11,">=3"),"Contact Procurement Services","")