User Profile
Integrity_Drywall
Copper Contributor
Joined Sep 14, 2022
User Widgets
Recent Discussions
Help on an IFS statement please
I am trying to write an IFS statement to make life easier while using an Excel sheet at work. I was told there is no limit on the amount of data in the IFS statement but I keep getting an error and I am not sure if I am doing the statement wrong or if it is just to large and I cant have it do what I want it to do. Basically what I am trying to do is have the square footage column auto populate based on the model name when you enter it. Can someone please help. The error is : Error Formula parse error The statement I am trying to us is: =IFS(D32="136 PARROT", 1940, D32="175 CABANA", 2393, D32="175 II CABANA BAY”, 2393, D32="176 BREEZE”,2083, D32="176 II BREEZE BAY”,1616, D32="177 COCONUT”,1685, D32="178 HAMMOCK”,2114, D32="178 II HAMMOCK BAY”,2114, D32="179 TRINIDAD”,2568, D32="179 II TRINIDAD BAY”,2549, D32="181 ST. BART”,2492, D32="184 ARUBA”,2336, D32="169 ANTIGUA”,1565, D32="171 BARBUDA”,1787, D32="171 II BARBUDA BAY”,0, D32="172 LUCIA”,1773, D32="173 NEVIS”,1865, D32="183 JAMAICA”,1507, D32="195 TORTOLA”,1743, D32="189 ALOHA”, 1466, D32="190 BAMBOO”, 1204, D32="191 CAMELLIA”,1321, D32="192 DREAMSICLE”,1378)") Any help would be greatly appreciated. Thank you
