Simple IF statement? Maybe not. Help!!

[cr2crf]

I need a formula that will satisfy this logic statement: If D2 = 1, subtract B3 from B2 and multiply the results by 1440. If D2 does not = 1, enter XXX. The answer goes in E2.

	A	B	C	D	E
1	DATE	TIME	GUARD	BUILDING	TIME
2	07/02/18	6:28:00	321	1
3	07/02/18	7:35:00	333

<tbody>
</tbody>

 

[Scott Huish]

=if(d2=1,(b3-b2)*1440,"xxx")

 

[cr2crf]

SOLVED!!!!

Obviously I was way overthinking this. The actual problem I am working on has so many other variable that I was in the weeds. thank you!

=if(d2=1,(b3-b2)*1440,"xxx")