Isnumber funtion

[uswyne]

Date	Amount	Paid Date
1/1/18	1000	I want the B column figure in this cell when I entered date in A1.

<tbody>
</tbody>

Please help

 

[AhoyNC]

Maybe:

=IF(ISNUMBER(A1),B1,"")

 

[uswyne]

Maybe:

=IF(ISNUMBER(A1),B1,"")

Thanks for your prompt reply.
Its working but disturbing in other cell calculation.

Date	Amount	Paid amount	Outstanding Balance	formula use in D column
	1000		1000	=iferror(B3-C3,"")
1/1/18	1000	1000	--	=iferror(B3-C3,"")

<tbody>
</tbody>

but when i used formula given by you it works in Coloumn C but coloumn D shows blank and this effect to calculate my total outstanding amount.

kindly look into this matter.

thanks
****** id="cke_pastebin" style="position: absolute; top: 159.815px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

=iferror(B1-B2,""

<tbody>
</tbody>

</body>

 

[Aladin Akyurek]

What is your formula for "total outstanding amount"?

 

[uswyne]

What is your formula for "total outstanding amount"?

=IFERROR(SUMIFS(Table15[OUTSTANDING AMOUNT],Table15[STATUS],"PAST DUE",Table15[SELECTED],1),"")

 

[Aladin Akyurek]

A SumIfs formula returns ordinarily a number, not an error, unless the sum range consists solely of error values.