IF

CovMatt

New Member
Joined
Jun 30, 2017
Messages
18
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,513
Office Version
365
Platform
Windows
Do you mean something like?
Code:
=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

New Member
Joined
Jun 30, 2017
Messages
18
Do you mean something like?
Code:
=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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,513
Office Version
365
Platform
Windows
You are welcome.
 

Forum statistics

Threads
1,082,635
Messages
5,366,687
Members
400,913
Latest member
SarahMS1

Some videos you may like

This Week's Hot Topics

Top