View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
flyers5182 flyers5182 is offline
external usenet poster
 
Posts: 3
Default Conditonal Formula

I need the correct conditional formula for the following example:

If the A column is (a personal initials e.g. WE), I want Column G to equal
Column F+170. If column A is different initails (e.g. OA), I need Column G
to equal Column F+140. The F Column is calender days (e.g. 3/10/07). I have
searched the help topics and tried to emulate formulas from previous similar
questions, but to no avail. Any tips would be great. The current formula I
have is (in cell G12):
=IF(A12=WE,F12+[170],IF(A12=OA,F12+[140]))

There are several conditions (10 initials total) What am I doing wrong??