Use IF function where value if not true is text

Hi
Im teaching myself excel and I need to be able to do the following calculation If Column A is Area 4 return $0.00 otherwise calculate $4000 for first 2000sqm in column b and then $100 for every 100sqm above 2000sqm. So for any value from 0-2000 it should return $4000, for any value above 2000 it should calculate $4000+ $100 for every 100sqm above 2000sqm. The Areas in column A could possibly change move within the list, but the square meterage is constant. eg What is is area 4 now might be in Area 7 later. It will always be Area 4 that should return 0.

I'm not sure that IF is the best way to resolve this Does anyone have any advice?

thanks

Hi Ive just tried it and it works. How would I get it to work if it was $100 for anything above 2000. eg 2001-2100sqm would cost $4100, 2101-2199 sqm would cost $4200 etc

Just replace the rounddown with roundup in the formula you already have
=IF(A2="Area4",0,IF(B2 < 2000,4000,4000+ROUNDUP((B2-2000)/100,0)*100))