ExcelIf.jpg
just wondering if anyone can help, ive attached a photo of my excel file where i need some help.
Basically in cell C5 i want a number to appear based on the information in cell C1 & C3
so if
C1 = 0 + C3 = 0 then C5 = 6
C1 = 0 + C3 = 1 then C5 = 3
C1 = 1 + C3 = 0 then C5 = 7
C1 = 1 + C3 = 1 then C5 = 4
C1 = 2 + C3 = 0 then C5 = 8
C1 = 2 + C3 = 1 then C5 = 5
and if its not any of these then i want C5 to appear blank.
Can anyone help?
Thanks
Bookmarks