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