hey in google excel how can i keep a blank space blank?
=IF(B3>D3,3,if(B3<D3,0,if(B3=D3,1,"")))
how can i say if b3 and d3 are blank stay blank.
thanks
hey in google excel how can i keep a blank space blank?
=IF(B3>D3,3,if(B3<D3,0,if(B3=D3,1,"")))
how can i say if b3 and d3 are blank stay blank.
thanks
Maybe - =IF(B3+D3=0,"",IF(B3>D3,3,IF(B3<D3,0,IF(B3=D3,1,""))))
Cheers!
Deep Dave
found a work around thanks for ur help also.
No problem..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks