IF Statement works in Excel but not G Sheet?

Web Applications Asked by Taylor on July 24, 2020

I have a simple IF statement in Google Sheets that is not computing correctly but it is computing correctly in Excel. The formula is =IF(G15="TRUE",1,0) and G15 is a cell with "TRUE" in it and the result is 0. I have checked the format of my reference cell and it is plain text.

Can someone tell me why this is not computing as 1?

Google Sheet Screenshot

Add your own answers!

Related Questions

Google Sheets: Lookup Value that falls after a Timestamp

0  Asked on January 23, 2021 by user261687


Twitter trending list not correct

1  Asked on January 23, 2021 by beth202


Can I send support questions to Google via email?

1  Asked on January 17, 2021 by mafu


Email forwarding to Gmail and SPF

1  Asked on January 13, 2021 by daunpunk


Why is my Twitter Page in Arabic?

1  Asked on January 10, 2021 by mariana-beaumont


How to sort files in folder by date created?

3  Asked on January 8, 2021 by user1306322


Why I am getting this error message from Gmail?

0  Asked on January 4, 2021 by abu-bakar-saadat


Ask a Question

Get help from others!

© 2022 All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir