Hi,
I have two formula which I want to merge-
1.=IF(C12="","",IF(C12=E12,"same",""))
2.=IF(D12="","",IF(D12=F12,"same",""))
The first formula says that if C12 & E12 are same i.e it must be numeric value then result will display "same",else space.Pls note that C12 & E12 might contains space i.e blank in both C12 & E12 in that case also it will display"same" becoz both are same,this blank should be ignored.Similarly No.2 formula also but different references.
I have two formula which I want to merge-
1.=IF(C12="","",IF(C12=E12,"same",""))
2.=IF(D12="","",IF(D12=F12,"same",""))
The first formula says that if C12 & E12 are same i.e it must be numeric value then result will display "same",else space.Pls note that C12 & E12 might contains space i.e blank in both C12 & E12 in that case also it will display"same" becoz both are same,this blank should be ignored.Similarly No.2 formula also but different references.