Trying to do a proposal template

%3CLINGO-SUB%20id%3D%22lingo-sub-1722310%22%20slang%3D%22en-US%22%3ETrying%20to%20do%20a%20proposal%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1722310%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20compare%20multiple%20cells%20to%20come%20up%20with%20an%20answer.%26nbsp%3B%20If%20you%20open%20the%20attached%20spreadsheet%2C%20I%20need%20to%20look%20on%20the%20Proposal%20Finance%20page%20and%20compare%20if%20the%20Hosting%20Option%20is%20either%20SaaS%20or%20Self%20Host%2C%20then%20compare%20of%20the%20Type%20of%20Processing%20is%20Full%20Medical%20or%20Dental%20and%20then%20determine%20if%20the%20Primary%20Subscribers%20are%20between%200%20-%2010%2C000%20then%20under%20Recurring%20Monthly%20Maintenance%20it%20will%20look%20at%20Rates%20to%20select%20the%20correct%20minimum%20lives%20with%20the%20correct%20cost.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20if%20I%20can%20do%20this%20or%20not%2C%20but%20thought%20I%20would%20give%20this%20a%20try%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1724317%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20do%20a%20proposal%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1724317%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EExcel%20community%20is%20here%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1724370%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20do%20a%20proposal%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1724370%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F310193%22%20target%3D%22_blank%22%3E%40HotCakeX%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20also%20mark%20the%20conversation%20post%20as%20inappropriate%20after%20which%20the%20moderators%20will%20move%20the%20entire%20post%20to%20the%20correct%20space.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to compare multiple cells to come up with an answer.  If you open the attached spreadsheet, I need to look on the Proposal Finance page and compare if the Hosting Option is either SaaS or Self Host, then compare of the Type of Processing is Full Medical or Dental and then determine if the Primary Subscribers are between 0 - 10,000 then under Recurring Monthly Maintenance it will look at Rates to select the correct minimum lives with the correct cost.

 

I don't know if I can do this or not, but thought I would give this a try

3 Replies
Highlighted
Highlighted

@HotCakeX 

You can also mark the conversation post as inappropriate after which the moderators will move the entire post to the correct space.

Highlighted
I moved it to the Excel community board.