multiple calculations from different cells with result in one cell

[colinheap]

Hi, I am new to this and need some help with a formula I am trying to write.

edited post, as I realised that the screenshot attachment makes much more sense than trying to show within post.


EXPENSE MONTHLY ANNUALLY MONTHLY COST ANNUAL COST

BILL £4.00 £4.00 £48.00
BILL £120.00 £10.00 £120.00
BILL £260.00 £21.67 £260.00
BILL £12.00 £12.00 £144.00
BILL £19.00 £19.00 £228.00
BILL £14.63 £14.63 £175.56
BILL £550.00 £45.83 £550.00
BILL £94.00 £94.00 £1,128.00

For my bills I want to work out first the monthly cost e.g. monthly(B) figure OR annual (C) /12 - and give the result in column (D)
And then work out the annual cost e.g. monthly (B) *12 OR annual figure - and give the result in column (E)

So if there is no figure in the monthly column (B), the calculation will be dividing the annual column figure by 12 and vice versa, if there is no figure in the annual column (C) then the calculation will be multiplying the figure by 12

This is probably a very simple calculation to do, but I am struggling to make sense of calculating results from different columns to give a result in the same cell.

hope my explanation of what I am trying to achieve makes sense, and someone can help me.

[Richard Buttrey]

Hi, and welcome to the forum

Please don't upload pictures when you already have a workbook - see guidance in the rules area. None of us are inclined to waste time merely duplicating your efforts. Help us to help you and you'll get a much better response.

Manually add the results you expect in your workbook and in a note tell us which are the result cells and if it's not blindingly obvious how you arrived at them.
Then upload the workbook.