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

Gers
Gers Posts: 13,578 Forumite
Part of the Furniture 10,000 Posts Photogenic Name Dropper
in Techie Stuff
I want to put in a formula that inserts 'No' in cell G if £60.00 is in cell F or 'Yes' if £70.00 is in cell F.

I'd appreciate any help here please.

Cell F Cell G
£60.00 No
£70.00 Yes

Comments

  • [Deleted User]
    [Deleted User] Posts: 0 Newbie
    Part of the Furniture 1,000 Posts Name Dropper
    =IF(G1=70,"yes",IF(G1=60,"no","")) will return a blank when G1 is neither 60 nor 70. If you leave out the last "", it will return FALSE.
  • Gers
    Gers Posts: 13,578 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    jack_pott wrote: »
    =IF(G1=70,"yes",IF(G1=60,"no","")) will return a blank when G1 is neither 60 nor 70. If you leave out the last "", it will return FALSE.


    Thanks so much! I had to change the cell info to the other way around and put in a number. And it worked.

    :beer:
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

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
  • 178.1K Life & Family
  • 260.6K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.
Update Your Picture