Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
Very new to all this! I want to set up cells showing a percentage difference. I've figured out how to get it to do that but want to have a blank cell if no data has been entered into one of the other cells i.e price before increase = A, price after increase = B and C = % diff. If I don't enter a value in B how can I make sure C is blank? Also would you recommend keeping formulas in a separate part of the worksheet and returning the answer to C. If so how would I do that. Sorry this is a bit rambly -- Mifty |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Changes when data entered in referenced range | Excel Discussion (Misc queries) | |||
REPOST: How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
eliminate data entered to a worksheet that copies to another work. | Excel Worksheet Functions | |||
Formulas (If linked data is not null, then insert "Complete" in ce | Excel Worksheet Functions | |||
Formulas in source data | Charts and Charting in Excel |