If Statement containing a Sum —


If A1 contains Z, I want the sum of A2 and A3 If A1 contains S, I want 0 =IF(A1=”Z”,SUM(A2+A3),IF(A1=”S”,0,”0.00″))

via If Statement containing a Sum —

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s