Home |
Search |
Today's Posts |
#1
|
|||
|
|||
REPLACE
need to replace values in cells B1, C1, D1, E1, and F1 IF A1 =0
thank you in advance! jane (again ) :( been one of THOSE days!) |
#2
|
|||
|
|||
Hi!
Are the values in those cells manually entered? To do what you want requires that each of those cells has a formula in it. But, at the same time you can't also manually enter hard coded values in them. You can either have a formula or a hard coded value but not both. You could do something like this in each of the cells. For example, in cell B1: =IF(A1=0,100,50) Meaning: if A1 = 0 then the value in cell B1 is 100 otherwise, it's 50. Biff -----Original Message----- need to replace values in cells B1, C1, D1, E1, and F1 IF A1 =0 thank you in advance! jane (again ) :( been one of THOSE days!) . |
#3
|
|||
|
|||
Sounds like you need to use an IF statement in cells B1, C1, D1, E1 and F1.
"Jane" wrote: need to replace values in cells B1, C1, D1, E1, and F1 IF A1 =0 thank you in advance! jane (again ) :( been one of THOSE days!) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace - Quickest Option? | Excel Worksheet Functions | |||
GLOBAL search and replace | New Users to Excel | |||
Search - replace NOT in formulas | Excel Worksheet Functions | |||
Replace using wildcards | Excel Discussion (Misc queries) | |||
VB Find and Replace | Excel Worksheet Functions |