hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,213
- Office Version
- 2010
- Platform
- Windows
- Mobile
C3:C7 generates numerical values. It can be +ve value or –ve value or 0
B2=+ve integer
F3:F7=IF value of a cell of C contains digits>$B$2 then 0 else C
How to accomplish?
Thanks in advance
B2=+ve integer
F3:F7=IF value of a cell of C contains digits>$B$2 then 0 else C
How to accomplish?
Thanks in advance
Book2.xlsx | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
2 | 4 | ||||||
3 | 142 | 142 | |||||
4 | 144.669 | 142.669 | |||||
5 | 14568 | 0 | |||||
6 | 1 | 1 | |||||
7 | 0 | 0 | |||||
8 | -14789.56 | 0 | |||||
9 | 4444 | 4444 | |||||
10 | 44445 | 0 | |||||
Sheet6 |