IF function

[Waleed]

Hi,
if I have numbers in cells as
B1 4
B2 5
B3 6
B5
B6
B5 and B6 empty (no numbers inside these cells, but in future I will add
numbers to these cells), and I want to format C5 and set a formula in as
IF(B6(has any number inside);(B6-B1)) and C5 return the difference between
B6-B1 only if there is number in B6, otherwise leave C5 empty
Thanks

 

[Pete_UK]

Put this in C5:

=IF(B6="","",B6-B1)

Hope this helps.

Pete