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
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