Forum Discussion

mslagle1's avatar
mslagle1
Copper Contributor
Jul 21, 2022
Solved

Formula Help!

I am trying to do a spreadsheet where the user enters the final retail price and we know the tax rate - what formula will figure the base retail?   In other words, if I know the tax rate is 20% and...
  • PeterBartholomew1's avatar
    Jul 21, 2022
    = retail / (1+taxRate)
    Using 365 'retail' could reference an entire array of values.

Resources