agonysWeeper
Board Regular
- Joined
- Feb 4, 2011
- Messages
- 146
CU11=H11+K11+N11+Q11+T11+W11+Z11+AC11+AF11+AI11+AL11+AO11+AR11+AU11+AX11+BA11+BD11+BG11+BJ11+BM11+BP11+BS11+BV11+BY11+CB11+CE11+CH11+CK11+CN11+CQ11+CT11
H11 to CT11 has a =IF(OR(CO11="",CP11=""),"",(CP11-CO11)*24) formula setup
Row11 has already data so everything is okay, but next row which is Row12 has no data so every cell has "" since the formula setup is =IF(OR(CO11="",CP11=""),"",(CP11-CO11)*24) then the CU12 just showing #VALUE!
Can anyone fix this?
thanks
H11 to CT11 has a =IF(OR(CO11="",CP11=""),"",(CP11-CO11)*24) formula setup
Row11 has already data so everything is okay, but next row which is Row12 has no data so every cell has "" since the formula setup is =IF(OR(CO11="",CP11=""),"",(CP11-CO11)*24) then the CU12 just showing #VALUE!
Can anyone fix this?
thanks
