Can you please help?

New Contributor

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! 

 

4 Replies

Hi @AZSUMMER2022 

 

Not sure if I understood you right, 

 

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

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

@AZSUMMER2022 Perhaps as shown in the picture below?

 

Screenshot 2022-04-23 at 06.02.08.png

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

 

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