The spread between highest and lowest

Premium

In E1, work out how far apart the quotes are, the highest minus the lowest. Subtract MIN from MAX in one formula.

E1
ABCDEF
1Supplier Quote Spread
2Acme 1240
3Brightline 1385
4Corvus 1190
5Delta Parts 1460
6Everline 1310
7
8

Premium lesson

Unlock MIN, MAX and LARGE and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:ROUND, ROUNDUP and ROUNDDOWNRelative and absolute references

It comes up in this mock test: Excel assessment (Indeed format)

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?