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!) |
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!) . |
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!) |
All times are GMT +1. The time now is 09:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com