Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Which formula?
Office 2007
I am looking for a formula that will do the following; If cell B6 equals Belmont, then cell B7 should equal 8.00, if cell B6 equals SPS, then cell B7 should equal 8.50, if cell B6 equals Cascade or Net or Special, then cell B7 should equal 9.00 I also have to be able to add more names to this formula. |