View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Greg is offline
external usenet poster
 
Posts: 331
Default One column determins what formula to use

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