Hi everyone. I want to set up a formula such that if the contents of cell A1 equals the number 650, that number is automatically copied (or, alternately, the other cell becomes equal) to cell H1.
Can anyone give me a hand?
Hi everyone. I want to set up a formula such that if the contents of cell A1 equals the number 650, that number is automatically copied (or, alternately, the other cell becomes equal) to cell H1.
Can anyone give me a hand?
Assuming I understood your question correctly, in whichever cell you want the rule to apply, try this:
Please Login or Register to view this content.
Spread the love, add to the Rep
"None of us are as smart as all of us."
Formula:Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
The first formula produced a circular reference error. The second one worked. Thank you for helping me.
There are 2 other small things I'd like to set up if possible. I noticed when I enter the formula and hit enter that the cell then presents a 0 which sits there until the condition (cell A1=650) is satisfied. Is there a way to keep the cell blank unless the condition is satisfied?
Also, if cell A1 is deleted (the number 650 is removed), the 650 remains in cell H1. I want H1 to become blank again if A1 becomes blank. Is this hard to set up?
Try
=IF(A1=650,A1,"")
Life's a spreadsheet, Excel!
Say thanks, Click *
That works perfectly. Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks