ISBLANK function???
Say I have this
1 2
A f1 f2
B ? ?
How do I leave B1 and B2 blank if their corresponding
f1 and f2 functions in A1 and A2 respectively are either
0 or blank. Again in psedo-code
A1=(if(blah), some_value, "")
B1=if(OR(ISBLANK(A1), A1=0), "", some_value)
Similar for A2/B2
--
- Zilla
(Remove XSPAM)
|