Help with formula in spreadsheet to calculate fee

[Kyle]

I have limited experience on excel and need a bit of help. I have a spreadsheet with info on that is populate with a T for rue and F for false against a list of items. What i want is a formula that will show that if the cell contains T it will populate the cell with £15 if it says F it - £0. Now there will be various columns and rows so the list down the left with various columns where T could be in with a different values, example T in column c needs to equal £15, T in column D - £190, T in column E needs to show £87.

 

Hope this makes sense.

Edited March 4, 2015 by Dos_Box

[LosOjos]

I have limited experience on excel and need a bit of help. I have a spreadsheet with info on that is populate with a T for rue and F for false against a list of items. What i want is a formula that will show that if the cell contains T it will populate the cell with £15 if it says F it - £0. Now there will be various columns and rows so the list down the left with various columns where T could be in with a different values, example T in column c needs to equal £15, T in column D - £190, T in column E needs to show £87.

 

Hope this makes sense.

 

There are a couple of ways to do this. Personally, I'd use a SUMIF here as it's a simple true/false test, but SUMPRODUCT is worth learning and understanding as you can do some much more complicated formulae with it.

 

Example of how both work in this scenario is attached for you.

sum example.xlsx

[Kyle]

Hi Los thansk for this, its nearly what i want. Ideally i want the cost to replace the T or F in the given cell and the heading of the column to be the item we are charging for.

[LosOjos]

Hi Los thansk for this, its nearly what i want. Ideally i want the cost to replace the T or F in the given cell and the heading of the column to be the item we are charging for.

 

Do you mean automatically? So if a user enters a 'T', it's automatically replaced with the cost? If so, that'll require some VBA.

 

The headings are up to you, I just made them up for example's sake - the important part is the costs listed above them; it just provides an easy way to update costs or add new columns, but you can hide that row before users see it.