A basic question sorry! I have this formula below, I would like it to show blank (so nothing) if there is nothing in the cell its looking at. At the moment it still shows 'Debiting' when I copy it down.
=IF(A2>0,"Crediting","Debiting")
Thanks
A basic question sorry! I have this formula below, I would like it to show blank (so nothing) if there is nothing in the cell its looking at. At the moment it still shows 'Debiting' when I copy it down.
=IF(A2>0,"Crediting","Debiting")
Thanks
Try this in B2 and copied down.
=IF(A2="","",IF(A2>0,"Crediting","Debiting"))
You could try >> =IF(A2<>"",IF(A2>0,"Crediting","Debiting"),"")
HTH
Regards, Jeff
You may need to add another IF condition to account for the three options Debiting, Crediting and empty cell.
e.g. =IF(A6>0,"Crediting",IF(A6<0,"Debiting",""))
Thanks both they work
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks