Fill Range Issue

Help Activities
1

Dear Experts

I want to use fill range to fill a formula in a range
But my formula with text in it and it turns out error

I think it should be sth relative to double quotation marks

May I know what is the correct way to write text in formula in fill range?

image

Thank you for your advise in advance

2

Hi @yangyq10

Give like below

"=IF(B2=C2,""Correct"",""Incorrect"")"

Regards,

3

Hi @yangyq10

"=IF(B2=C2,""Correct"",""Incorrect"")"

This image shows an automation workflow process that uses an Excel file to fill a range of cells in column D with a formula to check if values in column B and C are equal, indicating "Correct" or "Incorrect" accordingly. (Captioned by AI)
This image shows an automation workflow process that uses an Excel file to fill a range of cells in column D with a formula to check if values in column B and C are equal, indicating "Correct" or "Incorrect" accordingly. (Captioned by AI)690×674 24.3 KB

4

@lrtetala Thank you~

5

@pravallikapaluri Thank you~

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.