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
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