Anyone a spreadsheet/macro whizz?

southernscouser

Thanks for everyones help.

One last thing. When I copy and paste the formula down the column, it puts £0.00 in all the boxes. Is it possible for them not to be there until that row is filled in? :think:

I've uploaded it here if anyone would mind taking a look.

http://www.mediafire.com/?sharekey=6cc98bceadcd41d367cd7f7bd65f7eef1c4412ba6da74c41ce018c8114394287

southernscouser

southernscouser wrote: »

Thanks for everyones help.

One last thing. When I copy and paste the formula down the column, it puts £0.00 in all the boxes. Is it possible for them not to be there until that row is filled in? :think:

I've uploaded it here if anyone would mind taking a look.

http://www.mediafire.com/?sharekey=6cc98bceadcd41d367cd7f7bd65f7eef1c4412ba6da74c41ce018c8114394287

Anyone able to help at all?

michaelro

One way would be to hide zero values.

Using 2007

Tools / Options / Advanced

Un-check 'Show a zero in cells that have a zero value'

In 2003
Tools / Options / General (??From memory)
Un-check a description that is similar to above.

fredsnail

southernscouser wrote: »

Thanks for everyones help.

One last thing. When I copy and paste the formula down the column, it puts £0.00 in all the boxes. Is it possible for them not to be there until that row is filled in? :think:

I've uploaded it here if anyone would mind taking a look.

http://www.mediafire.com/?sharekey=6cc98bceadcd41d367cd7f7bd65f7eef1c4412ba6da74c41ce018c8114394287

You could also amend your formula:

=IF(C3="";0;IF(OR(C3="Qualifier";C3="Arb";C3="casino offer");H3-D3;H3))