Jump to content
Sign in to follow this  

Excel Squad Builder Help

Recommended Posts

I'm making an excel spreadsheet squad builder that i intend to upload for the community when done. I have all the data entered and tables set up.

However, I need help because I'm no excel pro and am having a hard time writing some formulas for data entry restrictions.

For example, in dealing with Ship Modifications, there are 3 available but each ship is only allowed to take one. I want a formula that will restrict a ship to one mod.

So how do i write the formula? Lets say that cell A1 is Engine upgrade, B1 is Shield Upgrade and C1 is Stealth device.

I need excel to allow only one cell from A1, B1, C1, to have a maximum value of 1.

I tried COUNTIF(A1:C1,">2") but anything under 2 triggers the error lol. I have a feeling this can be done with IF and COUNTIF functions but I'm at a loss as to how to do it.

Any help is greatly appreciated!

Share this post

Link to post
Share on other sites

Because i have to be online to use it, or use my browser. There was another older excel squad builder and it was great.




I found myself using it all the time. But the guy who made it doesn't seem to want to make another so I decided to have a go at making one. An Excel squad builder has a superior layout to the html one imho.


Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...