vipulgos
Active Member
- Joined
- Aug 17, 2002
- Messages
- 335
- Office Version
- 2010
- Platform
- Windows
I've formula like :
=if(A1>15000,concatenate("looking to scenerio the amount will be ",B1),A1)
Iwant to see the result of this formula as under:
"looking to scenerio the amount will be 25000"
(25000 is the figure in cell B1)
is it possible?
=if(A1>15000,concatenate("looking to scenerio the amount will be ",B1),A1)
Iwant to see the result of this formula as under:
"looking to scenerio the amount will be 25000"
(25000 is the figure in cell B1)
is it possible?