Thread: IF Function (I THINK) Excel 2003
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default IF Function (I THINK) Excel 2003
.. In cell C2, if B2= W, C2 should be 2 if B2= L, C2 should be .5

In C2: =IF(B2="W",2,IF(B2="L",0.5,""))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---
Reply With QuoteReply With Quote