Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to create a IF formula to return certain information:
If B2=COMERCIAL FINANCE I want it to return certain numbers like if b2=comercial finance then return 24567 if comercial finance is not selected I want it to be blank There will be a list to choose from like COMERCIAL FINANCE=2345 CONSUMER & INDUSTRIAL=3455 CONSUMER HOME SERVICES=4579 And so forth |