AnswerBun.com

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 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir