+ Reply to Thread
Results 1 to 18 of 18

Cell Greater than zero to display a cost

  1. #1
    Registered User
    Join Date
    11-30-2007
    Location
    Lancashire, UK
    MS-Off Ver
    1908
    Posts
    62

    Question Cell Greater than zero to display a cost

    Hi,

    I need help with a formula,

    If a cell is greater than zero I want another cell to display £4.95

    What would be the formula for this.

    Thanks in advance.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Cell Greater than zero to display a cost

    It would be this in B1:

    =IF(A1>0,4.95,")

    where A1 is the cell that you are looking at and B1 is the cell in which you want the monetary amount to appear.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    11-30-2007
    Location
    Lancashire, UK
    MS-Off Ver
    1908
    Posts
    62

    Re: Cell Greater than zero to display a cost

    Thank you, this works fine in one column but when I add the same formula to another column, changing the cell number the value is there but invisible ?
    Last edited by AliGW; 08-09-2020 at 09:43 AM. Reason: Please don't quote unnecessarily!

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Cell Greater than zero to display a cost

    Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Cell Greater than zero to display a cost

    You will have got something wrong, or failed to tell us something crucial. As Alan says, please attach a sample workbook.

  6. #6
    Registered User
    Join Date
    11-30-2007
    Location
    Lancashire, UK
    MS-Off Ver
    1908
    Posts
    62

    Re: Cell Greater than zero to display a cost

    Thanks Please see attachment
    Attached Files Attached Files

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Cell Greater than zero to display a cost

    I don't see where you have attempted the formula - where should I looking?

  8. #8
    Registered User
    Join Date
    11-30-2007
    Location
    Lancashire, UK
    MS-Off Ver
    1908
    Posts
    62

    Re: Cell Greater than zero to display a cost

    Its D3, the 4.95 in red, when I add the formula to F3 and H3 for example, it disappears, but when your in the cell its showing
    Last edited by Sharr76; 08-09-2020 at 10:04 AM.

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Cell Greater than zero to display a cost

    OK, so why did you put it there? What's the intended purpose?

    Please explain in WORDS exactly what you are trying to achieve.

  10. #10
    Registered User
    Join Date
    11-30-2007
    Location
    Lancashire, UK
    MS-Off Ver
    1908
    Posts
    62

    Re: Cell Greater than zero to display a cost

    Basically if there is a value of greater than zero in column D, F, H etc, there will be a postage cost £4.95, I want to show this cost in red so as I now that's an additional cost I have to pay.

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Cell Greater than zero to display a cost

    So you want it to appear if any of the rows in D, F or H are not empty?

    Why don't you just add the cost into the formula for each row instead of reminding yourself? It doesn't seem to be a very sensible method to me, if I have understood you correctly.

  12. #12
    Registered User
    Join Date
    11-30-2007
    Location
    Lancashire, UK
    MS-Off Ver
    1908
    Posts
    62

    Re: Cell Greater than zero to display a cost

    What is the reason for me not actually being able to see the figure in other columns apart from D3?

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Cell Greater than zero to display a cost

    Because you have put the formula in D3 and nowhere else. Where else are you expecting to see it?

    Again, please explain what you are trying to achieve, then we can tell you how to do it.

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Cell Greater than zero to display a cost

    F3 contains:

    =IF(F4>0,4.95,"")

    F4 is 0, so the formula returns blank.

  15. #15
    Registered User
    Join Date
    11-30-2007
    Location
    Lancashire, UK
    MS-Off Ver
    1908
    Posts
    62

    Re: Cell Greater than zero to display a cost

    Ahh I understand now what you mean, so what I need to do it say anything that is greater than zero in F4, 5, 6, 7 etc

  16. #16
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Cell Greater than zero to display a cost

    You still are not being completely clear, but how about this?

    =IF(SUM($F$4:$F$7)>0,4.95,"")

  17. #17
    Registered User
    Join Date
    11-30-2007
    Location
    Lancashire, UK
    MS-Off Ver
    1908
    Posts
    62

    Re: Cell Greater than zero to display a cost

    That worked perfect, thank you very much

  18. #18
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Cell Greater than zero to display a cost

    Ah, OK - good!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Cell to display 0 if the value is greater than 10
    By CPAC in forum Excel General
    Replies: 3
    Last Post: 05-19-2016, 09:57 AM
  2. [SOLVED] Display a row if a cell value is greater than zero
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 07:05 PM
  3. Display a row if a cell value is greater than zero
    By vmerrill in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  4. Display a row if a cell value is greater than zero
    By Anne Troy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  5. Display a row if a cell value is greater than zero
    By vmerrill in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. Display a row if a cell value is greater than zero
    By vmerrill in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. Don't display row if cell value is greater than zero
    By vmerrill in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2005, 02:05 PM

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