I am trying to generate an invoice from a spreadsheet. There is no pay for hours 9 and 10.
Pay rate is in a1 (Assume $1 / hr)
number of hours is in b2
total pay ends up in b3
If b2 = 7, then pay is $7,
If b2 = 8, then pay is $8,
If b2 = 9, then pay is $8,
If b2 = 10, then pay is $8,
If b2 = 11, then pay is $9,
if b2 = 12, then pay is $10
I am lost as to what the formula should be
Any suggestions?
Bookmarks