IF

[CovMatt]

Could someone please confirm best formula for

MINIMUM CHARGE - £ 5,000

IF A RAFFLE DOESN'T REACH £ 5,000 THEN THE AMOUNT COLLECTED ROLLS OVER

I.E.

RAFFLE - £ 2000

FORMULA CALCULATES THAT £ 3000 ROLLS OVER

Also I have a formula tab with workings and styles i.e. cell sizes but when I copy and paste it doesn't copy cell sizes etc..

Thanks

 

[Joe4]

Do you mean something like?

=IF(A1<5000,5000-A1,0)

If not, please provide more detail on exactly what your data looks like and what you are looking for.

 

[CovMatt]

Do you mean something like?

=IF(A1<5000,5000-A1,0)

If not, please provide more detail on exactly what your data looks like and what you are looking for.

Perfect Thanks Joe

 

[Joe4]

You are welcome.