If & Or Formula?

[misterbaker]

Hi All,

I'm looking for a formula that will look at 2 cells:

Cell A2 can contain - "Yes", "No", "Other"
Cell A3 can contain a date
Cell A4 is where the formula sits

I would like my formula to look at Cell A2 and return the "Yes" or "No" responses however if the response is "Other" then i would like it to return cell A3 instead. Does that make sense? It's probably really simple but i'm stumbling around like a fool with my formula's and can't seem to get it right!

As always the help is very much appreciated!
Thanks

[Glenn Kennedy]

With A4 formatted as date:

=IF(A2="","",IF(A2="Other",A3,A2))

[misterbaker]

Sorry, i dont think i worded that correctly, and i actually provided info on the cells incorrectly. Attached is an example of how i would like it to work...

[misterbaker]

I actually figured it out, but thank you for the support anyway!

[Glenn Kennedy]

I'd have used:

=IF(A2="","",IF(A2="Other",B2,A2))