Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Attempting to get a formula to work, with no luck;
Dates will be input into cells G5, H5, I5, and J5. Formula goes into G6 so that if any of the above four cells in blank, a 0 (zero) is put into G6, if they are all populated return a 1 (one). I tried =IF(ISBLANK(OR(A1,B1,C1,D1)),"0",1), but it returns a 1 under all circumstances. This is obviously the wrong approach. Any suggestions greatly appreciated. Paul |