We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
excel formula help please
longforgotten
Posts: 1,093 Forumite
in Techie Stuff
I'm faffing about with formula and not succeeding:(
What I would like to do in my excel spreadsheet is...
If, I put the number 1 in column D , I want the figure in column F to automatically be also shown in column H
Your help would be much appreciated
Thank goodness its Friday
What I would like to do in my excel spreadsheet is...
If, I put the number 1 in column D , I want the figure in column F to automatically be also shown in column H
Your help would be much appreciated
Thank goodness its Friday
0
Comments
-
In H1 put:
=IF(D1=1,F1,"")
copy down as required.Stompa0 -
Thank you so much Stomp.
I admit your formula did not work for me initially but that was my fault. The cell I was putting the number into was a 'text' cell, once I changed it to a 'number' cell all was well.
You gave me the formula and it made me learn, and take note, of what I was doing. Thanks again.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.1K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.6K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178K Life & Family
- 260.5K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards