Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

HOW TO DO THIS IN EXCEL

EXCEL FORMULA

Best Answer JoMalig , 29 March 2022 - 03:26 AM

Hi, It works for me including on Google Sheets!  It worked. Thank you so much. The problem why it didn't work the first time was because of the semicolon ;   it should... Go to the full post »


  • Please log in to reply

#1
JoMalig

JoMalig

    Member

  • Member
  • PipPip
  • 51 posts

Hello,

 

I just want to ask how to do this in excel or rather what formula I will use? Please see image below;

 

ScreenShot_20220316161223.jpeg

 

In cell A3, if I put a number equal to any of the numbers under E column then it will show the word SUBMITTED in cell B3.

If the number I put in cell A3 is equal to any of the numbers under F column then it will show the word PENDING in cell B3.

If the number I put in cell A3 is equal to any of the numbers under G column then it will show the word FINISHED in cell B3.

If the number I put in cell A3 is not equal to any of the numbers under column E, F and G, then B3 will remain blank.

 

Thanks in advance.

 


  • 0

Advertisements


#2
nasdaq

nasdaq

    Visiting Staff

  • Visiting Consultant
  • 166 posts
Hello, Welcome to MALWARETIPS.
I'm nasdaq and will be helping you.
 
If you can please print this topic it will make it easier for you to follow the instructions and complete all of the necessary steps in the order listed.
===
 
The IF statement is well explain in this topic.
 
 
Hope that helps.

  • 0

#3
SleepyDude

SleepyDude

    Trusted Helper

  • Malware Removal
  • 4,974 posts

Hi,

 

Check if this works for you!

 

on B2 to check value from A2

=IF(COUNTIF(E:E;A2)>0;E1;IF(COUNTIF(F:F;A2)>0;F1;IF(COUNTIF(G:G;A2)>0;G1;"")))


  • 0

#4
JoMalig

JoMalig

    Member

  • Topic Starter
  • Member
  • PipPip
  • 51 posts

 

Hello, Welcome to MALWARETIPS.
I'm nasdaq and will be helping you.
 
If you can please print this topic it will make it easier for you to follow the instructions and complete all of the necessary steps in the order listed.
===
 
The IF statement is well explain in this topic.
 
 
Hope that helps.

 

 Thanks for the welcome  :geek:

 

Sorry but it did not explain what to do in my case. But thanks anyway.

 

 

Hi,

 

Check if this works for you!

 

on B2 to check value from A2

=IF(COUNTIF(E:E;A2)>0;E1;IF(COUNTIF(F:F;A2)>0;F1;IF(COUNTIF(G:G;A2)>0;G1;"")))

Sorry, It didn't work.  :no:


  • 0

#5
SleepyDude

SleepyDude

    Trusted Helper

  • Malware Removal
  • 4,974 posts

Hi,

 

It works for me including on Google Sheets!

 

5GzNA8.png


  • 1

#6
JoMalig

JoMalig

    Member

  • Topic Starter
  • Member
  • PipPip
  • 51 posts
✓  Best Answer

Hi,

 

It works for me including on Google Sheets!

 

5GzNA8.png

 

It worked. Thank you so much.

 

The problem why it didn't work the first time was because of the semicolon ;   it should be comma. 


  • 0

#7
SleepyDude

SleepyDude

    Trusted Helper

  • Malware Removal
  • 4,974 posts

The use of ; or , in Excel depends on the Operating System Regional Settings, for me its ;

 

It seems that Google Sheets uses , and did automatically adjusted the pasted formula.


  • 0

#8
JoMalig

JoMalig

    Member

  • Topic Starter
  • Member
  • PipPip
  • 51 posts

I see. I didn't know that. that's new to me  :D

Thanks again mate.


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP