View Single Post
  #11 (permalink)  
Old 01-18-2011, 08:24
karina721's Avatar
karina721 karina721 is offline
Senior Member
Join Date: Sep 2008
Location: Northwest Indiana
Posts: 2,652
Default 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.

Mom to 2 girls, 7 & 4
Reply With Quote
Sponsored Links