98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Functions
Functions
Resolved · Low Priority · Version 2003
Sarah has attended:
Excel Advanced course
Functions
how would I add a specific value to an existing value in a cell, but only if the cell value is above zero?
RE: functions
Hi Sarah
Thanks for your post you can do this by creating something called conditional formatting how to is below
select the cells you need - then go to the format menu - clcik conditional format
choose the option you want from the ones in the window then make sure you add the format you need then click OK
hope this helps, if not reply to this post for further assistance
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
RE: functions
Hi,
Maybe I'm doing something wrong, but "Conditional Formatting" only allows me to change the way the cell looks, or the way the content of the cell looks, dependent on certain variables. But what I want to do is to add
RE: functions
Hi Sarah
Firstly apologies for the long delay in coming back to you on this.
You may have found a solution already, however if not I would suggest using an IF function to add 1.95 to any cell that contains a value greater than zero, or stay the same (i.e. display 0) if there is a zero value in the cell.
Say for example that your value is in D3. Enter a formula in E3 (for the delivery charge) as follows:
=if(D3>0,D3+1.95,0)
Then you can copy the formula down column D to other cells.
I hope this helps. I can create and send an example of this if you like - please indicate by reply post if this would be useful.
Kind regards
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:The Easiest Way to See a Sum or Average in Excel 2010Did you know the quickest and most simple way of working out the average or sum of a set of numbers? |