Apr 22 2022 03:18 PM
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!
Apr 22 2022 06:16 PM
Apr 22 2022 06:28 PM
Apr 22 2022 09:03 PM
@AZSUMMER2022 Perhaps as shown in the picture below?
=IF(AND(ISBLANK(A1),ISBLANK(B1)),"",(A1="X")*20+(B1="X")*200)