On 25 nov, 20:58, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Plot from =IF((B40),(C4/B4),NA()) instead of *=IF((B40),(C4/B4),"")
--
David Biddulph
"Co" wrote in message
...
Hi All,
I found this spreadsheet on the net:
http://spreadsheets.google.com/ccc?k...k_rZ_TXRU7KIg#
It is a log for runners. The chart displays only the days that contain
some data.
Those are the days that a person did a run.
I'm tried this on my own chart but it always comes up with the line
dropping to zero
value when no data was found on that day.
How is this done?
Regards
Marco
When I do this:
=IF((B120);(C12/B12);NA())
I get an error in the empty field:
#NAME?
If I do this in the field:
=IF((B120),(C12/B12),NA())
I get an error saying:
Error in the formula.
Marco