corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » General Chat » Computer Question


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Computer Question
seanreay1986
Member
Registered: 30th Jul 04
Location: Washington, Tyne and Wear
User status: Offline
1st Mar 05 at 22:38   View User's Profile U2U Member Reply With Quote
in excel i am making a spreadsheet and i want to put a formula in so that when one of the cells is populated another 2 cells are cleared.

Thanks
Swiftie
Member
Registered: 7th Jan 05
Location: Greater London
User status: Offline
1st Mar 05 at 22:41   View User's Profile U2U Member Reply With Quote
Believe you may need to dable in VB coding for this.

But I could be proven wrong.
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
1st Mar 05 at 22:43   View Garage View User's Profile U2U Member Reply With Quote
In the cell you want clearing:

=IF (A1<>"","","hello")

ie. if A1 not equal to nothing then cell you're in is set to "" else its set to say hello.
seanreay1986
Member
Registered: 30th Jul 04
Location: Washington, Tyne and Wear
User status: Offline
1st Mar 05 at 22:53   View User's Profile U2U Member Reply With Quote
the first two cells will have dates in them and when i put a date in the third cell i automatically want it to delete the first two cells. Could anyone do a quick example for me please.

 
New Topic
New Poll

Corsa Sport » Message Board » General Chat » Computer Question 23 database queries in 0.0790939 seconds