| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=OR and =IF Help
I'm trying to do a formula that will look at what someone types in a cell. If
what was typed is one specific word or another, something happens. But if the person didn't type one of those words, something else will happen. Any ideas? tia |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=OR and =IF Help
=IF(OR(A1="word1",A1="word2"),"Do this","do something else")
HTH "Pam" wrote: I'm trying to do a formula that will look at what someone types in a cell. If what was typed is one specific word or another, something happens. But if the person didn't type one of those words, something else will happen. Any ideas? tia |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=OR and =IF Help
Try this:
=IF(A1="x","First Option",IF(A1="y","Second Option","Unspecified")) Mike "Pam" wrote: I'm trying to do a formula that will look at what someone types in a cell. If what was typed is one specific word or another, something happens. But if the person didn't type one of those words, something else will happen. Any ideas? tia |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=OR and =IF Help
Thanks so much to both of you. I was on the right track, just needed a bit of
a push! :) "Mike H" wrote: Try this: =IF(A1="x","First Option",IF(A1="y","Second Option","Unspecified")) Mike "Pam" wrote: I'm trying to do a formula that will look at what someone types in a cell. If what was typed is one specific word or another, something happens. But if the person didn't type one of those words, something else will happen. Any ideas? tia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
