santoshloka
Board Regular
- Joined
- Aug 31, 2017
- Messages
- 125
D5=1 , 1cells need to appear as well as 1 tabular form need to appear
D5=2 , 2 cells need to appear as well as 2 tabular form need to appear
D5=3 , 3 cells need to appear as well as 3 tabular form need to appear
i have used this formula,,it is working when the condition is met it is appearing
=IF(D5>=0,"Cell-1","")
=IF(D5>=1,"Cell-2","")
=IF(D5>=2,"Cell-3","")
=IF(D5>=3,"Cell-4","")
iam using this formula to apper Cell 1 in D8
there is a issue with tabual form,ito appear one table which formula i have to use
Example of tablular form U3:AD4 for Cell1
<tbody>
</tbody>This is one table
3more tables are there like this
can yu guys suggets formula or any macro
D5=2 , 2 cells need to appear as well as 2 tabular form need to appear
D5=3 , 3 cells need to appear as well as 3 tabular form need to appear
i have used this formula,,it is working when the condition is met it is appearing
=IF(D5>=0,"Cell-1","")
=IF(D5>=1,"Cell-2","")
=IF(D5>=2,"Cell-3","")
=IF(D5>=3,"Cell-4","")
iam using this formula to apper Cell 1 in D8
there is a issue with tabual form,ito appear one table which formula i have to use
Example of tablular form U3:AD4 for Cell1
H(mm) | QTY | A | B | D | C | E | F | K | J |
2 | 3 | 5 | 5 | 5 | 8 | 8 | 8 | 8 | 7 |
<tbody>
</tbody>
3more tables are there like this
can yu guys suggets formula or any macro
Last edited: