Need help with formula

[Permits]

I have a spreadsheet that shows the price of a building in one cell and I want to put a cell next to it that will say "YES" if the price of the building is $2500 or more. Can that be done?

[ramenado]

Building Price check
$25,000.00 .IF(G15>=2500,"YES","NO")
$2,500.00 YES
$3,000.00 YES
$1,000.00 NO
$1,500.00 NO
$5,000.00 YES

[Pete_UK]

Yes, it can be done, but before we can offer you any help you will need to change your title, according to Forum Rule 01. Most people come here looking for help with a formula (or macro), so your current title is of no use - it should describe what you are trying to achieve, and I an sure you have been a member of the forum long enough to have seen messages about thread titles before.

Please change it, and at the same time describe how your data is laid out in a bit more detail.

Pete