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.
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.
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.
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!
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
You will have got something wrong, or failed to tell us something crucial. As Alan says, please attach a sample workbook.
Thanks Please see attachment
I don't see where you have attempted the formula - where should I looking?
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.
OK, so why did you put it there? What's the intended purpose?
Please explain in WORDS exactly what you are trying to achieve.
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.
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.
What is the reason for me not actually being able to see the figure in other columns apart from D3?
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.
F3 contains:
=IF(F4>0,4.95,"")
F4 is 0, so the formula returns blank.
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
You still are not being completely clear, but how about this?
=IF(SUM($F$4:$F$7)>0,4.95,"")
That worked perfect, thank you very much
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks