Forum Discussion
Excel formula/function help
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,"Con...
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","")