Avatar of Frank .S
Frank .S
Flag for Australia

asked on 

excel - IFstatement

hi experts, could you help with an ifstatement in the following cell K6.
if cell I6 is blank show nothing, otherwise.
if cell I6=F6 & J6 ="sqr set" then show G6
if cell I6=F6 & J6 ="cornice" then show H6
if cell I6=F7 & J6 ="sqr set" then show G7
if cell I6=F7 & J6 ="cornice" then show H7
if cell I6=F8 & J6 ="sqr set" then show G8
if cell I6=F8 & J6 ="cornice" then show H8
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment

8/22/2022 - Mon