hello my masters, i want your help to amend for this formula
Code:
=IF(OR($B3="",$C3=""),"",$C3*VLOOKUP($C$1&$F3,Prices!$B$3:$F$714,4,0)+$D3*VLOOKUP($C$1&$F3,Prices!$B$3:$F$714,5,0))
to can to deduct 1 pax each number of pax in Cell J1 Value
in the same items each Invoice
I mean for Example ,if I have in this invoice like more than 10 pax in
compact car … it should be deduct 1 pax each 10 pax( cell J1)
Code:
=IF(OR($B3="",$C3=""),"",$C3*VLOOKUP($C$1&$F3,Prices!$B$3:$F$714,4,0)+$D3*VLOOKUP($C$1&$F3,Prices!$B$3:$F$714,5,0))
to can to deduct 1 pax each number of pax in Cell J1 Value
in the same items each Invoice
I mean for Example ,if I have in this invoice like more than 10 pax in
compact car … it should be deduct 1 pax each 10 pax( cell J1)
Attachments
Last edited by a moderator: