Hello,

If anyone familiar with Excel could offer some help that would be very appreciated. I don’t think this puzzle is too difficult.

=IF(E12=“x”,M12=H12*1.2)

This is what I have at the moment but it’s not doing what I want; rather it is simply returning a value “True”.

I have a table. If an x or an X is placed in the E column, I would like the program to take the numerical value which has been input to the H column of the same row and multiply that value by 1.2. If there is no x in the E column, then the H column value should stay the same.

Ultimately I want to be able to add all the results together from multiple rows for a total at the bottom as well.

eg (showing just the E and H columns)

X……1
……..1
Total 2.2

eg 2
X…..1
X…..1
Total 2.4

eg 3
…….1
…….1
Total 2

The M column in my above formula is there because I have the idea stuck in my head that I would have to re-print each of the values whether multiplied by 1.2 or not in order to add them all up at the end. If there is a way to skip that I would rather use that way.

Thanks in anticipation :)

In M12 put:

=IF(E12=“x”,H12*1.2, H12)

Then sum the values in column M.

There are fancy things you can do with Sumproduct to avoid the extra column, but it’s easier to use the column. You can always move it somewhere else if you don’t want it on view.

Sweet!

Thanks Rev.

LOL I came here after Excel help too. Might if I piggy back off this thread?

I have a maximised window with a workbook that has the max/min button out of view. How do I maximise the workbook?

Divine Angel said:

LOL I came here after Excel help too. Might if I piggy back off this thread?

I have a maximised window with a workbook that has the max/min button out of view. How do I maximise the workbook?

menu > view > full screen

CrazyNeutrino said:

Divine Angel said:

LOL I came here after Excel help too. Might if I piggy back off this thread?

I have a maximised window with a workbook that has the max/min button out of view. How do I maximise the workbook?

menu > view > full screen

That’s not what I want.

Divine Angel said:

LOL I came here after Excel help too. Might if I piggy back off this thread?

I have a maximised window with a workbook that has the max/min button out of view. How do I maximise the workbook?

Double-click on the bar at the top of the workbook.

The Rev Dodgson said:

Divine Angel said:

LOL I came here after Excel help too. Might if I piggy back off this thread?

I have a maximised window with a workbook that has the max/min button out of view. How do I maximise the workbook?

Double-click on the bar at the top of the workbook.

That bar is hidden

some Excel shortcuts here

http://dmcritchie.mvps.org/excel/excelwindow.htm

http://www.excelforum.com/excel-general/747313-excel-workbook-wont-maximize-for-full-screen.html

Divine Angel said:

The Rev Dodgson said:

Divine Angel said:

LOL I came here after Excel help too. Might if I piggy back off this thread?

I have a maximised window with a workbook that has the max/min button out of view. How do I maximise the workbook?

Double-click on the bar at the top of the workbook.

That bar is hidden

Try View-Arrange all then

What version are you using?

It’s not protected and the restore button makes it a small window in one corner. I want the workbook to fit the full-sized window.

2007 (work computer)

Divine Angel said:

2007 (work computer)

View – arrange all should work then.

alt + spacebar > restore?

The Rev Dodgson said:

Divine Angel said:

2007 (work computer)

View – arrange all should work then.

Ta. It’s not quite perfect but I’m tired of playing around with it.

• It’s not quite perfect but I’m tired of playing around with it

Said the lady to the bishop…