contestada

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

Respuesta :

20099724

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

Let's use python

[tex]\tt Amount=input("Enter \: amount")[/tex]

[tex]\tt if \:Amount<100:[/tex]

[tex]\tt \quad Ship==5[/tex]

[tex]\tt else:[/tex]

[tex]\tt\quad ship==0[/tex]

Otras preguntas