Home > Forum Home > Automating Data Analysis Tasks > IF Statement | Share |
Forum Topic | Post Reply Login |
If Statement | Rate this: (3/5 from 1 vote) |
Hello I need some help on If statements
I now want if the date is 00/01/1900 in first column then it should say Presales in, if its in 2nd column then CDC in and in 3r column CDC due. If there is no 00/01/1900 then it should say CDC out. Please help Thanks deepak | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Dee | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Posted by dkalra1981 on |
Replies - Displaying 1 to 3 of 3 | Order Replies By: Most recent | Chronological | Highest Rated |
Rate this: (3/5 from 1 vote) =VLOOKUP(date value to be found,column range,column offset: 1 for the same column,FALSE for exact match only) | |
Excel Business Forums Administrator | |
Posted by Excel Helper on |
Rate this: (3/5 from 1 vote) I don't know how to apply the VLOOKUP function. Can anyone pls help how to apply VLOOKUP function? Thanks Deepak | |
Dee | |
Posted by dkalra1981 on |
Rate this: (3/5 from 1 vote) An IF function can then be used to evaluate which column (if any) contains the date desired. The functions can be combined into one cell by embedding them; however it will be easier to first create the functions in separate cells and optionally join them at the end. | |
Excel Business Forums Administrator | |
Posted by Excel Helper on |
Displaying page 1 of 1 |
Excel templates and solutions matched for IF Statement:Solutions: Income Statement Balance Sheet |