Hi.
I need your help.
In the attachment there is a small spreadsheet.
I need two formulas/rules in Sheet1:
1) If in column F and G the value is #N/A the formula has to change it to 0.
2) In column H in each cell has to be the value only from colored font cell from columns A,B,C,D (same row).
The result should be:
Cell H2 5.00
Cell H3 7.00
Cell H4 10.00
Cell H5 7.00
Cell H6 5.00
Cell H7 5.00
Cell H8 6.00
....
Bookmarks