Excel

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Excel

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

October 27th, 2005, 05:55 AM

alannoble26 alannoble26 is offline

alannoble26 is offline

Authorized User

Join Date: Oct 2005

Posts: 15

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Excel

I want to create a formula that allows me to see a variance between a cell figure which should be set at 9.75%.

The formula I have is
if(c7 = 9.75%, "No Variance", C7-9.75)

This doesnt work as cell is a percentage, why is this?

Can someone help

Old

October 27th, 2005, 10:12 AM

Martin Outlaw Martin Outlaw is offline

Martin Outlaw is offline

Authorized User

Join Date: Jun 2004

Posts: 12

Thanks: 0

Thanked 0 Times in 0 Posts

Default

in cell C8 (for example)format as percentage
=IF(C7=0.0975, "No Variance", C7-0.0975)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem in opening excel file in MS Excel 2000	kallol	Visual C++	0	November 16th, 2007 05:48 AM
ASP to Excel - excel output formatting issue	mat41	Classic ASP Professional	0	August 13th, 2006 06:41 AM
write multi-sheet Excel w/o Excel.Application	manmoth	Classic ASP Components	2	November 22nd, 2005 10:56 AM
Excel in win 2000 to excel winxp (excel 2002)	Max	Excel VBA	3	August 28th, 2003 04:44 AM