I am currently taking a course that involves **Google Spreadsheets** and was wondering if there was a specific limit to how long a formula can be in one cell and how many functions are the max. I am looking at a formula I have created and it gives me the error *#ERROR "Formula parse error."* the formula and functions I am using are,

```
=IF(AND(C4="K",E4=0),"S",IF(AND(C4="K",E4=4),"K",IF(AND(C4="S",E4=2),"K",IF(AND(C4="S",E4=0)"S",IF(AND(C4="OUT",E4=1),"N/A",0)))))
```

very complicated, I know. Although I'm not quite sure how else to do it.

If someone could help me out with that, that'd be amazing.

A formula can be long 50000 characters. After that, you will receive:

There was a problem

Your input contains more than the maximum of 50000 characters in a single cell.

However, there is a nice workaround that allows you to exceed this limit: **https://stackoverflow.com/a/55070275/5632629**

As for the "used functions" - no such limit.

As for your formula - try it like this:

`=IF(AND(C4="K", E4=0), "S", IF(AND(C4="K", E4=4), "K", IF(AND(C4="S", E4=2), "K", IF(AND(C4="S", E4=0), "S", IF(AND(C4="OUT", E4=1), "N/A", 0)))))`

July 11, 2019 22:22 PM

- Serverfault Help
- Superuser Help
- Ubuntu Help
- Webapps Help
- Webmasters Help
- Programmers Help
- Dba Help
- Drupal Help
- Wordpress Help
- Magento Help
- Joomla Help
- Android Help
- Apple Help
- Game Help
- Gaming Help
- Blender Help
- Ux Help
- Cooking Help
- Photo Help
- Stats Help
- Math Help
- Diy Help
- Gis Help
- Tex Help
- Meta Help
- Electronics Help
- Stackoverflow Help
- Bitcoin Help
- Ethereum Help