![]() |
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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 12:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com