PDA

View Full Version : Excel 2007 and if statements



OhGorgeous1
06-05-2009, 06:42 AM
Hi Guys

Got a real one for you. (not sure if this is possible):banghead::dunno:help

I have an excel 2007 spreadsheet with a formula/macro that needs to do the following:

If B3 is blank and C3 is blank make D3 blank
OR
If B3 is blank and C3 has a value put "starter" in D3
OR
If the values in B3 and C3 are the same put "No Change" in D3
OR
If the values in B3 and C3 are different put "Change" in D3
OR
If B3 has a value but C3 is blank put "Left" in D3

I hope this makes sense, I have attached a sample spreadsheet.

Heres wishing!!! : pray2:

Niki

Bob Phillips
06-05-2009, 07:41 AM
Try

=IF(B3="",IF(C3="","","Starter"),IF(C3="","Left",IF(B3=C3,"No Change","Changed")))

OhGorgeous1
06-05-2009, 02:22 PM
Try

=IF(B3="",IF(C3="","","Starter"),IF(C3="","Left",IF(B3=C3,"No Change","Changed")))

That works brill, many many thanks (I was sort of along the right lines then?)

Niki

Bob Phillips
06-06-2009, 07:57 AM
Yes, and you could probably have msade yours work, I just thought it could be a tad mor simplistic, which is the way I think :)