if column 1=3 then column 2, if not return no value-Help?
 

I have been given the assignment to devise the following formula in an Excel
Spreadsheet:
Mean Average Value

Formula: if column 1=3 then column2, if not return No value.

It doesn't make sense to me, can someone help? I haven't used Excel in the
past few years. It seems incomplete????

if column 1=3 then column 2, if not return no value-Help?
 

hi!

something like

in C1: =if(A1=3,B1,"")

-via135



okie Wrote:
I have been given the assignment to devise the following formula in an
Excel
Spreadsheet:
Mean Average Value

Formula: if column 1=3 then column2, if not return No value.

It doesn't make sense to me, can someone help? I haven't used Excel in
the
past few years. It seems incomplete????


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=541768