Isnumber funtion

[uswyne]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Amount[/TD]
[TD]Paid Date[/TD]
[/TR]
[TR]
[TD]1/1/18[/TD]
[TD]1000[/TD]
[TD]I want the B column figure in this cell when I entered date in A1.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Amount[/TD]
[TD]Paid amount[/TD]
[TD]Outstanding Balance[/TD]
[TD]formula use in D column[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1000[/TD]
[TD][/TD]
[TD]1000[/TD]
[TD]=iferror(B3-C3,"")[/TD]
[/TR]
[TR]
[TD]1/1/18[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]--[/TD]
[TD]=iferror(B3-C3,"")[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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;">[TABLE="width: 500"]
<tbody>[TR]
[TD]=iferror(B1-B2,""[/TD]
[/TR]
</tbody>[/TABLE]
</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.