Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
How do I do Conditonal Formatting with formula progression | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions |