Hide total till number input

[oscarff]

Hello I have a question, We have a formula that would give us the total after the first box had been entered example

box a1 is empty and so is box b1
we enter in a number in a1 let say 100 when when we hit enter or tab it would auto add 750 and show the result in b1
when I look at the old sheet and click on box b1 its showing -SUM(a1+750)
the problem is that before we input numbers in a1 its showing the 750 even is a1 is empty and we need to kepp the 750 hidden till a number is input in a1
Please help i have spent a few hours trying to figure this out

 

[Austin Lang]

Try this..

In B1, use this formula..

=IF(ISBLANK(A1),"",A1+750)

 

[oscarff]

I tested it out and I got an error please see attached image

 

[Fluff]

You are missing a comma after the " "

 

[oscarff]

So I think I broke it more , I need some major help soo the fist pic is what I have and the second pic shows it gives me the calculation , in the third pic it shows the VALUE error the problem is i have this calculation copied to about 100 cell since we update this sheet every hour and it need to calculate but I need to not see the value error and I need it to be blank till we input numbers , I will I could upload a video of it working before the new guy save over the original copy.

 

[Fluff]

Try

if(A1="","",A1+750)
if(b1="","",B1+C1)
if(D1="","",E1-D1)