Hi,
I want to write the following formula and I get part of it then lose another and am getting nowhere fast. Could someone help please?
I have 2 columns of figures in Column AF and AH.
There could be #N/A in column AF or AH or both.
I want to put a sum in column AK2 which is along these lines (I'll write it as I would speak it)
If the contents of both AF2 and AH2 = #N/A Then AK2 0
That covers where boths columns have #N/A
If the contents of AF2 = #N/A Then AK2 = AH2
That covers where just column AF has #N/A
If the contents of AH2 = #N/A Then AK2 = AF2
That covers where just column AH has #N/A
Many thanks for any help.
Bookmarks