Excel IF function
Chopstick
Registered Posts: 6
I am trying to find out how to do the IF function for
Sales
£130,005.00
£172,964.00
£134,135.00
£234,510.00
£195,944.00
£126,994.00
Average of total sales is £165,758.67
Basically if 130,005.00 is greater than the average 165,785.67 by 4% then 130,005.00 will get 1% of the average165,758.67...How do I work this out.
Sales
£130,005.00
£172,964.00
£134,135.00
£234,510.00
£195,944.00
£126,994.00
Average of total sales is £165,758.67
Basically if 130,005.00 is greater than the average 165,785.67 by 4% then 130,005.00 will get 1% of the average165,758.67...How do I work this out.
0
Comments

I believe the following answers question, using the average as A7 and the rest of details above =IF(A2>$A$7*1.04,A2*1.02)  basically if A2 £130,005) is greater than A7 ($ for absolute reference) *4% then return A2 x2%Donna Curling  AAT Tutor
www.completebookkeeping.co.uk0 
Thank You I know where I was going wrong now...I was doing 0.04 and 0.02 rather than 1.04 and 1.02..
Thanks so Much
1 
no problem, glad you got there
Donna Curling  AAT Tutor
www.completebookkeeping.co.uk0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.5K For AAT students
 321 NEW! Qualifications 2022
 164 General Qualifications 2022 discussion
 11 AAT Level 2 Certificate in Accounting
 56 AAT Level 3 Diploma in Accounting
 87 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 92 Software
 273 Tax
 135 Bookkeeping
 7.2K General accounting discussion
 200 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 345 Feedback for AAT
 2.8K Chat and offtopic discussion
 582 Job postings
 16 Who can benefit from AAT?
 36 Where can AAT take me?
 42 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 66 AAT membership