Thread
:
2 formulas in 1 cell
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_]
external usenet poster
Posts: 8,651
2 formulas in 1 cell
=IF(B2<B1,0,IF(B2B1,B1,"I haven't a clue what answer is required if B2=B1,
so I haven't specfied it"))
--
David Biddulph
MAX wrote:
If cell B2<B1 answer in A2 must be 0 and
if cell B2B1 answer in A2 must be equal to B1
Reply With Quote
David Biddulph[_2_]
View Public Profile
Find all posts by David Biddulph[_2_]
2 formulas in 1 cell