I am developing a spreadsheet to track sales. The sheet has built in drop-downs. I have a drop down with four options (ABS, A, V, or B) and each has an associated value.
I need an output cell that calculates if ABS then 350, if A then 125, if V then 125, and if B then 0 and then this result needs to be multipled by F27 cell. I started with this function below, but it did not inlcude the B category.
=IF(D27="ABS",350,125)*F27

I have also tried: =if(D27="ABS", if(D27="A", if(D27="V", if(D27="B", 350, 125, 125, 0))))
Do I need to use an OR or AND?
Please help out here as I have searched and have tried all that I can.
Thanks a bunch!