Assignment-1: Create New Conditional Column
surcharge
if ship_mode = “Same Day” then 20% or 0.2
else if ship_mode = “First Class” then 10% or 0.1
else if ship_mode = “Standard Class” then 5% or 0.5
else 0
total cost = (sales - profit ) * ( 1 + surcharge )
Batch ID(DS190523)
sir i did’t understand this assignment where to write and how to write what i do sir please explain cleary what i was do today is last day to submit assignment so please help me sir
@mohammedaliparkar342
1 Like
In excel you have to create a new column named total cost . You can submit the excel sheet @ganesh.sahithi2811
i have no idea this… please sir any sample please clearly explain
1 Like
like this you have to submit the assignment @ganesh.sahithi2811
but sir where i can get data &
where i can get sales,profit,costprice values sir
1 Like
Please ask your instructor or batchmates , they will provide you
thanku sir
i completed assignment
1 Like
