in the follow in spreadsheet I would like to have an inection level expressed as a percent of trees which have a 2 in the bleed column. one of the tricky things is that some nodes have less that 4 trees. So I would need to divide by 2 or 3 in those cases instead of 4 . So the bleed column is eith 1, 2 or blank and there are always 4 rows for each node. I need one infection level to coorespond to the each numbered node in column B.
If possible I would like to write it in visual basic instead of a complicated if/then statement.
Thanks for any help you can provide.
[/img]C:\Documents and Settings\admin\Recent\Desktop\temp.htm[/img]
If possible I would like to write it in visual basic instead of a complicated if/then statement.
Thanks for any help you can provide.
[/img]C:\Documents and Settings\admin\Recent\Desktop\temp.htm[/img]
