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
