Romano_odK
Active Member
- Joined
- Jun 4, 2020
- Messages
- 380
- Office Version
- 365
- Platform
- Windows
Good morning,
I am trying to make this IFS and AND function to work in the last column. If the value in the column VKE = 1000 and the value in column Doos = 1 then I want to see the value in column NwPrijs. My approach is obviously wrong because I get N/A everywhere. I need more of these AND function in the same formula so I thought using IFS and AND would be best.
Thank you for you time.
Romano
I am trying to make this IFS and AND function to work in the last column. If the value in the column VKE = 1000 and the value in column Doos = 1 then I want to see the value in column NwPrijs. My approach is obviously wrong because I get N/A everywhere. I need more of these AND function in the same formula so I thought using IFS and AND would be best.
Thank you for you time.
Romano
Onderhoud prijzen 9.4.04F.xlsm | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
G | H | I | J | K | L | M | N | |||
1 | ArtKW | ArtROTO | NwPrijs | Factor | Omschrijving | VKE | Doos | Column1 | ||
2 | 133000 | 538280 | 16,12 | 1 | Kunststof Rasterblok 6x2 mm blauw - 1000 stuks | 1000 | 1 | #N/A | ||
3 | 133001 | 538280 | 16,12 | 10 | Kunststof Rasterblok 6x2 mm blauw - 100 stuks | 100 | 10 | #N/A | ||
4 | 133002 | 538282 | 17,42 | 1 | Kunststof Rasterblok 6x3 mm rood - 1000 stuks | 1000 | 1 | #N/A | ||
5 | 133003 | 538282 | 17,42 | 10 | Kunststof Rasterblok 6x3 mm rood - 100 stuks | 100 | 10 | #N/A | ||
6 | 133004 | 538284 | 19,27 | 1 | Kunststof Rasterblok 6x4 mm geel - 1000 stuks | 1000 | 1 | #N/A | ||
7 | 133005 | 538284 | 19,27 | 10 | Kunststof Rasterblok 6x4 mm geel - 100 stuks | 100 | 10 | #N/A | ||
8 | 133006 | 538286 | 20,99 | 1 | Kunststof Rasterblok 6x5 mm groen - 1000 stuks | 1000 | 1 | #N/A | ||
9 | 133007 | 538286 | 20,99 | 10 | Kunststof Rasterblok 6x5 mm groen - 100 stuks | 100 | 10 | #N/A | ||
10 | 133008 | 538992 | 11,52 | 1 | Kunststof Rasterblok 8x1 mm wit - 1000 stuks | 1000 | 1 | #N/A | ||
11 | 133009 | 538992 | 11,52 | 10 | Kunststof Rasterblok 8x1 mm wit - 100 stuks | 100 | 10 | #N/A | ||
12 | 133010 | 538993 | 12,16 | 1 | Kunststof Rasterblok 8x2 mm blauw - 1000 stuks | 1000 | 1 | #N/A | ||
ROTO |
Cell Formulas | ||
---|---|---|
Range | Formula | |
N2:N12 | N2 | =IFS(AND(L2=1000,M2=1),I2) |