Ecel formula [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

I don't know how to make this formula work.
I am trying to make a spreadsheet that will populate a number based on my parameters.

If Cell A1 is = "P" and A2 is "N12b" Than Cell A3 is 15. The 15 is a value from a table.

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
=if(and(A1="P",A2="N12b",15,"")

if the conditions are not satisfied then the cell will be blank.

"The 15 is a value from a table." this is not clear.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!