Formula Question - Microsoft Community
Office / Excel / Windows other / Unknown/other
=if(b8="sintra",5,if(b8="vinyl",4.25,if(b8="plex",9.25,if(b8="graphics on sintra",3.32,0)))) formula have in excel spreadsheet, need know how change of words in drop down , pricing keep same formula. can me?
i need 3 drop downs in formula states:
sintra $5.00
vinyl $4.00
cut vinyl $4.50
thank you!
your formula be:
=if(b8="sintra",5,if(b8="vinyl",4,if(b8="cut vinyl",4.5,0)))
Office / Excel / Windows other / Unknown/other
Comments
Post a Comment