Fire_Chief
Well-known Member
- Joined
- Jun 21, 2003
- Messages
- 691
- Office Version
- 365
- Platform
- Windows
Can anyone tell me why this statement will not work?
I am in Sheet2 trying to get a value from Sheet1
=if(Sheet1!(MID(C3,3,1) = "H",1,0)
If the 3rd value in cell C3 ( Sheet1) = "H" I want a 1 otherwise a 0
Thanks
Marty
I am in Sheet2 trying to get a value from Sheet1
=if(Sheet1!(MID(C3,3,1) = "H",1,0)
If the 3rd value in cell C3 ( Sheet1) = "H" I want a 1 otherwise a 0
Thanks
Marty