Multiple IF's formula

[papasmurfuo9]

Hi

please could someone help with this formula, driving me nuts!


i have 3 cellls

B8, B13, B18

the formula is to go in b18


If b8 is 001 and b13 is 002, then b18 is 003

if b8 is blank and b13 is 001, then b18 should be 002

if b8 is 001 and b13 is blank then b18 should be 002

if b8 is blank and b13 is blank then b18 should be 001

many thanks in advance!!

[etaf]

If b8 is 001 and b13 is 002, then b18 is 003
if b8 is blank and b13 is 001, then b18 should be 002
if b8 is 001 and b13 is blank then b18 should be 002
if b8 is blank and b13 is blank then b18 should be 001

=IF( AND( B8="001", B13="002") , "003", IF( OR( AND( B8="",B13="001"), AND( B8="001", B13="")) , "002", IF( AND( B8="", B13=""), "001", "criteria for B8 and B13 not Met")))

[papasmurfuo9]

cheers!!!!!!!!!!

[etaf]

your welcome, post back if any further issues

[GIS2013]

Hi Papa. I'd like to suggest you the vba version (click the button in the sheet itself) .