Quote:
Originally Posted by sarajmen
thanks buddy formula works perfectly
|
Hello,
The following question was referred to the same formula
= IF (B21 = $ L $ 17, $ M $ 17, IF (B21 = $ L $ 18, $ M $ 18, E21 * (G21 * (1 + $ H $ 18))))
Can we define if B21 = any cell in column L and if for example L18 ... M18 or L223 .... Enter M223
thanks