Forum Discussion

Copper Contributor

Jan 19, 2024

Excel formula help - IF blank formula THEN use

How do I write this formula for excel: fill cell I# with data from cell F#, if cell F# is blank then fill with cell H#

HansVogelaar
MVP
Jan 22, 2024
kelly78728

In I2:

=IF(F2="", H2, F2)

Fill down.
- kelly78728
  Copper Contributor
  Jan 22, 2024
  Thank you!
EricStarker
Former Employee
Jan 22, 2024
kelly78728 Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.