Results 1 to 3 of 3

Less than zero show zero

Threaded View

sabrinigreen Less than zero show zero 10-05-2011, 12:37 PM
ConneXionLost Re: Less than zero show zero 10-05-2011, 12:41 PM
TMS Re: Less than zero show zero 10-05-2011, 12:45 PM
  1. #1
    Registered User
    Join Date
    09-28-2011
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2007
    Posts
    38

    Less than zero show zero

    Hello,
    I am working on an employee bonus sheet. If the amount is greater than zero, than they get a bonus, but if it is less than, they just get zero (not negative).

    However, when I tried to enter a formula for this, I got a circular reference warning b/c the cell I'm referencing in the formula is the cell it is in.

    Also, I want it it to display $0.00 if no text entered and if less than zero.

    There is already a formula in the cell to figure out the amount of the bonus, and I've put it a formula to show $0.00.

    This formula is in H491

    =IF(G491="","$0.00",(G491-8000)/1000*2.2)



    So can I put if (G491-8000)/1000*2.2 is less than zero, show zero. And if no data in G, or if zero or less than zero, show $0.00 ?

    Thank you

    ------
    The replies worked, I've given good reputation and am marking this as solved, thank you so much!
    Last edited by sabrinigreen; 10-05-2011 at 12:53 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1