Excel Formula Variances

[Erik456]

Greetings,
I have a quick question. If I wanted run a boolean logic test with variance on the test how would I do it? For Instance IF(D18=0,"True","False") but I am willing to allow a variance of + or - 5%. Hence any amount within greater or less than 5% variance would come back true.
Total=100
Hence any amount within greater or less than 5%of 100 would come back true. Think in terms of balancing a checkbook. If the amount is within 5% plus or minus it is adaquete.
Thanks in Advance

[oldchippy]

Not sure this is what you want. I'm assuming a total of 100 here. So if you have a SUM in say A4

=SUM(A1:A3) then in B4

=IF(AND(A4<=100+100*5%,A4>=100-100*5%),"OK","Not OK")

[Carim]

Hi,

If you are after variance and standard deviation ...
Take a look at var() and stdev() functions

HTH
Carim

[MrShorty]

What's in D18?

If I were looking at a problem like this, I would probably use a formula like =IF(and(0.95*100<D18,D18<1.05*100),"OK","Not OK") or =IF(AND(0.95<D18/100,D18/100<1.05),"OK","Not OK"). Make it fit your spreadsheet layout.

If you just want TRUE or FALSE returned, you can drop the IF function and just use =AND(....)