bronze

I can seem to get the formula syntax to get this right IF (A1 <>"" and B1<>"" and C1<>"") Then "Bronze" IF (A1 <>"" and B1<>"" and C1<>"" and D1<>"" and E1<>"") Then "Silver" IF (A1 <>"" and B1<>"" and C1<>"" and D1<>"" and E1<>"" and F1<>"" and G1<>"") Then "Gold"

Hi guys, I have a spreadsheet with multiple data validation lists. These basically allow the user to select Gold, Silver or Bronze specifications for building products. I would like to create an overall data validation list. Users would select Gold, Silver & Bronze for the overall standard of...

Please help, Skus are in column A, Color is column B, All I need is if column B =Satin Bronze remove 10 from the end of the sku of column A There are about 15 finishes so I will need to edit for each one but thus is the best wat to get to the base sku's. In the sample row 1 is Satin Bronze and...

<tbody> Name Section Class Score Medal Bob #C 9 98 Daniel #C 9 98 Jon #C 9 97 Tom #C 9 96 Alice #C 9 95 Elisabeth #C 9 95 Robert #C 9 91 Mertin #C 9 89 etc. </tbody> I'm trying to use a formula that allows me to choose the medal (gold, silver, bronze) gold -...

Hi All, Good Afternoon, I need to compare Sheet 1 <colgroup><col></colgroup><tbody> SLA 111 221 333 with Sheet 2 below table <colgroup><col><col><col></colgroup><tbody> Gold Silver Bronze 311 211 111 312 212 112 313 213 113 321 221 121 </tbody> </tbody> And return value...

I feel a bit blonde posting this. But I need an if statement and can't quite get it right. I want it to calculate a percentage then show a word based on the result. So there will be 4 words. If a2 is less than 90% of a1 then the word will show "Bronze" if a2 is 90-90% of a1 then the word will...

Hello - I have a spread sheet that has multiple carriers, metallics and rates. I'm looking to find the lowest carrier among bronze rates. The following formula works, however, I'm wondering if there is a way to write it w/out using { } as it is giving our API issues. Current formula...

Hello - I have a spread sheet that has multiple carriers, metallics and rates. I'm looking to find the lowest carrier among bronze rates. <tbody> Aetna BCBS Health Net Dean Geisinger Bronze 10 N/A 100 35 5 Bronze Plus 15 N/A 50 45 10 Gold 20 N/A 75 55 15...

I have a list of customers who have downloaded a product in column I of a worksheet. We categorise existing customers as 'Gold', 'Silver' or 'Bronze' . In a separate worksheet 'Customer Cats', I have 3 lists of these customers - one 'Gold' column, one 'Silver' and one 'Bronze' column - columns...