Re: Spreadsheet formula help real quick perty please!!!!!
Try this formula too.
You'll have your subtotal column & PP Fee Column, added those two together in the next column. Then in the next column type this formula =IF(This is where you put the column # of the subtotal plus PP fee total), "3", "")
So say it's A10 (subtotal) plus A11 (PP Fees) equal A12 (total of the two)
Your formula should read like this =IF(A12, "3", "")
If the cell is blank, it'll stay blank due to the ""
If someone adds their order, it'll pop up 3 because there's a number in that total cell.
HTH.
__________________
Mom to 2 girls, 7 & 4
