<= is tis less than or equal to?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to raise a now due alarm in a cell when the content of an
adjacent cell exceeds the limit. At this time the accoint is now due. My
formula is:

=IF(BB4<=$BC$3, "","Now Due")

If not due not returnign comment.

Iurgently seem your assistance. Many thanks
 
Not sure of your difficulty, but maybe all you need is

=IF(BB3<=$BC$3, "","Now Due")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Hi Kaylean,

Your posted formula has a space between the , and ""
So maybe
=IF(BB4<=$BC$3, "","Now Due")

Should be
=IF(BB4<=$BC$3,"","Now Due")

Is that perhaps the trouble?
Martin
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Greater, equal to or less than question 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Countif using less than or greater than criteria 3
Countifs with "or" embedded? 1
Less than Or Equal 2
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Finding the first value equal to or less than 0 3

Back
Top