| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
a conditional formula
I hope I am saying this correctly. I am trying to create a formula that would
give me the following result in cell A1. If the value in cell A2 is equal to horse return the value in A4, if not return will be blank. I want to sincerely thank in advance anyone who helps this novice user out. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
a conditional formula
=IF(A2="horse",A4,"")
Case matters, so "Horse" < "horse" < "HORSE". "vdmbqb" wrote: I hope I am saying this correctly. I am trying to create a formula that would give me the following result in cell A1. If the value in cell A2 is equal to horse return the value in A4, if not return will be blank. I want to sincerely thank in advance anyone who helps this novice user out. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
a conditional formula
=IF(A2="horse",A4,"")
"vdmbqb" wrote: I hope I am saying this correctly. I am trying to create a formula that would give me the following result in cell A1. If the value in cell A2 is equal to horse return the value in A4, if not return will be blank. I want to sincerely thank in advance anyone who helps this novice user out. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
a conditional formula
=IF(A2="horse",A4,"")
"vdmbqb" wrote: I hope I am saying this correctly. I am trying to create a formula that would give me the following result in cell A1. If the value in cell A2 is equal to horse return the value in A4, if not return will be blank. I want to sincerely thank in advance anyone who helps this novice user out. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
| Help With Conditional Formula | Excel Discussion (Misc queries) | |||
| Conditional Formula to indicate Formula in cell | New Users to Excel | |||
| Conditional Formula | Excel Worksheet Functions | |||
Linear Mode
