Can you please help?

[AZSUMMER2022]

Hi, 

I want to create a spreadsheet for a friend who is doing inspections. If cell has and "X" then add 20 and if cell next to it has and "X" add 200. So the 3rd column could be 20, 200 or 220. I'm just not sure how to formulate that. Thanks in advance! 

[#2]

Hi @AZSUMMER2022 

Not sure if I understood you right, 

=IF(A1<>0,IF(B1<>0,220,20),IF(B1<>0,200,0))

[#3]

IT'S A PASS OR "X" IN ONE COLUMN = 20, AND IF A PASS IN THE NEXT COLUMN, OR "X", THEN 200 SO I WANT THE 3RD COLUMN TO EITHER BE BLANK, 20 OR 220 ... I HOPE I'M EXPLAINING IT WELL ENOUGH. THANKS SO MUCH

[#4]

@AZSUMMER2022 Perhaps as shown in the picture below?

=IF(AND(ISBLANK(A1),ISBLANK(B1)),"",(A1="X")*20+(B1="X")*200)

[#5]

@Riny_van_Eekelen, thank you, I'll try that!