IF formula

Copper Contributor

Hi, please could you tell me what's wrong with this formula: =IF(SUM(D12:G12)=C12,''Balanced'',''Check'')

it's keep coming up with an error message

3 Replies

@Natalia700 It seems you have used pairs of single quotes around the words Balanced and Check. You should use regular quotation marks (i.e. double-quotes).

@Natalia700 

For the texts please use " instead of double '

 

thank you, I almost cried here why this doesn't work and the solution is so simple