Help!

Two cells reliant on each other

  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Problem Solvers RSS
Next:  old program  
Author Message
nessan



Joined: Mar 02, 2012
Posts: 1
PostPosted: Fri Mar 02, 2012 11:18 am    Post subject: Two cells reliant on each other

I am hoping someone can help me....please

I can get the cell to work if I do them separately but I would like to be able to enter in any field and the result put in the other.

Annual (A1) Monthly (B1)

Obviously ...
Annual is SUM(B1*12)
Monthly is SUM(A1/12)

How do I get them to work no matter what one I over type?? They are dependant on each other so it just gives an error.
Back to top
drwho07



Joined: Nov 29, 2007
Posts: 2274

Location: Central FL, USA
PostPosted: Sat Mar 03, 2012 10:40 am    Post subject:
Would you PLEASE, state exactly what you're talking about.

What program are you using, and what version?
Is this a spreadsheet?
Are you using formulas? (that can link cells together)

The more information you GIVE, the better answers you'll GET. Eh?

Cool
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Problem Solvers All times are: Eastern Time (US & Canada)
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum