gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 657
- Office Version
- 2019
- Platform
- Windows
Hello,
I need to alter $H4>0.1 (in I4 and I5) so if the cell(H:H) is blank then it doesn't populate.
I tried ISTEXT, but it doesn't work.
below is what I'm working with...
I need to alter $H4>0.1 (in I4 and I5) so if the cell(H:H) is blank then it doesn't populate.
I tried ISTEXT, but it doesn't work.
below is what I'm working with...
Cell Formulas | ||
---|---|---|
Range | Formula | |
H4 | H4 | =IFERROR(IF(AND($A4=$AY4,IFERROR($BA4>=0.6,TRUE),IFERROR($BB4>=0.6,TRUE),IFERROR($BC4>=0.525,TRUE),IFERROR($BD4>=0.525,TRUE),$AU4=$AY$4),$A4,""),"") |
H5 | H5 | =IFERROR(IF(AND($A5=$AY5,IFERROR($BA5>=0.6,TRUE),IFERROR($BB5>=0.6,TRUE),IFERROR($BC5>=0.525,TRUE),IFERROR($BD5>=0.525,TRUE),$AU5=$AY$5),$A5,""),"") |
I4,I6:I7 | I4 | =IF(AND($F4="",$H4>0.1),$B4,"") |
I5 | I5 | =IF(AND($F5="",ISTEXT($H5)),$B5,"") |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
H4:I35 | Cell | does not contain a blank value | text | NO |