Question

Christina needs to calculate the shipping costs for each invoice. The company charges a flat rate shipping charge of $5. Shipping charges are waived for invoices of $100 or more.

In cell H5, create a formula using the IF function and structured references to determine the shipping based on the following criteria:
a. If the value in the Amount column ([Amount]) is less than 100, the shipping charge is 5.
b. If not, the shipping charge is 0.
HELP ASAP PLEASE!!!!!! i keep using the formula =IF([Amount]<100,5,0) but it wont work right

Answer 1

Let's use python

`\tt if \:Amount<100:`

`\tt \quad Ship==5`

`\tt else:`

`\tt\quad ship==0`

Answer 2

its got to be B!!! correct me if i am wrong!