# Cell Greater than zero to display a cost

1. ## 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.

2. ## 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.

3. ## 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 ?

5. ## 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.

7. ## Re: Cell Greater than zero to display a cost

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

8. ## 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

9. ## 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. ## 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. ## 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. ## 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. ## 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. ## 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. ## 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. ## Re: Cell Greater than zero to display a cost

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

17. ## Re: Cell Greater than zero to display a cost

That worked perfect, thank you very much

18. ## Re: Cell Greater than zero to display a cost

Ah, OK - good!

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

#### 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