can anyone help?

MiNxYyY · 23 Feb 2011 at 16:57

More people viewing this section so thought i might get a faster response.

Basically i have been left to do the balancing for work but our systems have gone down and i have to use excel to work it out.

what i need to know is what formula code to use to show if the totals are over or under.

bledd · 23 Feb 2011 at 17:00

Use the 'Snipping tool' in Windows (type that into Start menu) to easily make screenshots

MiNxYyY · 23 Feb 2011 at 17:01

sorry picture fail

Efour · 23 Feb 2011 at 17:03

epic picture fail indeed :O

MiNxYyY · 23 Feb 2011 at 17:07

Re done the picture now.

does anyone understand excel formulas? need to figure it out :/

doiks14 · 23 Feb 2011 at 17:09

if totals are over or under what exactly? sorry, but I seem to have a hard time comprehending...

MiNxYyY · 23 Feb 2011 at 17:15

basically what it is, is we need to type in the code that shows if the totals are over or under....to see if opera or pdqs are over or under basically. I think its something like =IFN7>J7() something like that, sorry but i dont really understand either but ive been left with the job to work it out :/

loltim · 23 Feb 2011 at 17:21

http://www.homeandlearn.co.uk/excel2007/excel2007s6p1.html

bsoltan · 23 Feb 2011 at 17:27

Put this in cell O7

=IF(J7>N7,"Y","")

Put this in cell P7

=IF(N7>J7,"Y","")

Then drag them down to the bottom row.

This will test if the PDQ Total is greater than the Opera Total and put a Y in the PDQ Over cell, and test if Opera Total is greater than PDQ Total and put a Y in the Opera Over cell.

Is that what you need?

MiNxYyY · 23 Feb 2011 at 17:57

ye thats the one

thankyou