Try a structure like this...

=IF(C1="M",<your one formula,IF(C1="F",<your other formula,""))

--
Rick (MVP - Excel)


"Greg" wrote in message
...
I have Column C that has either M or F in the cell.
i would like to have a calculation in another column G
that if they put a M in column C it would use one formula and if they put
a
F in Column C it would use another formula.

what would be the proper way to go about this?

Thanks in Advance