Further to my previous message I kept trying & GOT IT TO WORK.
In my particular case
IF((B2:M32 0),B2:M32*3.936996," ")
This changes my old rain charts measured in 1/100 of an inch to
millimetres & leaves the blanks blank rather than replacing them with
0