Hello,
I need two formulae in the attached excel sheet (Taxi booking) under following conditions.
1) I need a Formula for the Cell L4. The taxi fare is Rs 100 for first 4Km and then Rs 12 per additional KM. The present formula being used is not perfect.
2) Also need a formula for cell P4. In case cash has been received then P4 should not calculate the service tax (Cell M4).
Kindly help
Best Regards
Rajiv
Hi,
Use below formula in L4
=IF(K4<=4,100,100+((K4-4)*12))
Use below formula in P4
=IF(O4=0,L4+M4+O4,L4+O4)
Thank you......
Thank You.....
If your thread is solved then please update as SOLVED
And do not forget to Add Reputation Points from Left Side....
Thank you........
Dear Arshad,
Thanks so much for your quick reply. P4 is now perfect. I just need one more condition in L4. If K4 is zero then L4 should also be zero. Rest remains same.
Hope to have ur further help.
Thanks
Rajiv
Originally Posted by arshad.99.ali
Like this
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Yes, Alkey formula can be used to get your desired output
Thank you.......
Thank you Alkey and Arshad, that works.
Hi Rajiv,
Please take a moment to mark your thread as SOLVED and Click * button to add Reputations points
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks