2 formulas in one cell?

[kyspi095]

Trying to get two formulas for one cell for a created estimate.
For example: D12 represents units/amounts with a data validation list from 1-10, while F12 represents the total fee. The formula is D12*625.
I shortly realized there are times a discount is given.
Therefore, E12 will represent 10%, 20%, and 30%- how can I keep the same formula for the total fee while adding a discount?

[Glenn Kennedy]

This, maybe?

=625*D12*(100-E12)/100

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[Pete_UK]

Adding a discount implies subtracting it, so you could try this in F12:

=IF(D12="","",D12*(1-E12)*625)

If the 625 can be variable depending on what has been ordered, then you could use a VLOOKUP table to return that value.

Hope this helps.

Pete

[kyspi095]

Can you show me an example of what you mean?

[Pete_UK]

If you are asking me, then I will need to see an example Excel workbook - the yellow banner at the top of the screen gives details of how you can attach a workbook to one of your posts.

Pete

[kyspi095]

I have included the attachment

[Pete_UK]

You have a cost for each of those procedures listed, and you have chosen to embed these within each formula, e.g. for Orthopantogram, pre-op it is 120, but on the next row it is 625 for a different procedure. This means that you have a different formula on each row, and, furthermore, if the charges change you will have to edit all those cells manually.

However, if you had a separate table which listed all the procedures and against each one you listed the charge, then you can use a VLOOKUP formula to bring the appropriate charge across, rather than hard-coding it within each cell. This gives you the advantage that if the charges change then you only need to change them within the table, where they are visible and easy to spot any mistakes.

The table could be in another area of the same sheet, but away from the main body, or you could put it on another sheet.

Hope this helps.

Pete