Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

functions

ResolvedVersion 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

Excel tip:

Date and time

CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.