Hi, i want to create multiple criteria formula with IF Function, which i am unable to solve under two conditions.
Formula:
=IF($F9=$AB$4:$BV$4,$Y9,"")
Code: in F column
Row AB4 up to Row BV4 Particular code to match with F Column & return value through Column Y.
This is the first criteria.
I want to do more with this formula. I want to less 20 % VAT on amount in column Y, Plus if i put the criteria EC 20 % than it should not less or add EC 20 % on value in column Y.
Can anyone please help me out with this issue.
Following is the snap shot taken from working papers.
Thanks.
Can you add a sample worksheet, as the above doesnt make a lot of sense to me.
=IF($F9=$AB$4:$BV$4,$Y9,"") looks like an array formula (so Ctrl Shift Enter on Excel 2016) or Spill cells on new Excel.
Row AB4 up to Row BV4 these are columns not rows
jpgs are no good as you cant see whhere stuff is
Hi Purfleet.
Sorry for not uploading any files. Please find the attached file. I really appreciate for your help.
I want to add three criteria to this sheet, whenever i enter the values in Column "L" which is receipt side & Column "X" which is payment side. When i add code it will automatically bring the values to respected columns when the code is matched. But now i want to add two more criteria.
1. When i select VAT type 20% it will deduct 20% vat from receipt or payment.
2. When i select VAT type EC 20% it will not do any deduction.
3. Values shall be under only where the code is matched.
Thanks.
