Hello again guys,
I need your help again because I'm trying to use an very simple If function and it doesn't work and don't understand why.
I have the columns G and H which give me a result in the F column (G + H).
I'm trying to tell excel to consider the value in the F column when there is one. If not I want to return the value to H or G column but it doesn't work.
I tried with
=IF(F8<>0;G8:H8;F8)
with IF(BLANK(F8)
and IF(F9=0; etc)
Please find attached and excel fil with example.
Thanks
Bookmarks