abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,429
- Office Version
- 2019
- 2010
- Platform
- Windows
hello
i have this formula but it gives me error =IF(D2:D99="";F1:F99="";(F2+D3)-E3) i have value in column d, e i would showing empty cell in column f if col d,e ="" and if is not it applys this formula =(F2+D3)-E3) so this formula changes in column d,e contain values so it should this = =(F3+D4)-E4) ,=(F4+D5)-E5) and so on
i have this formula but it gives me error =IF(D2:D99="";F1:F99="";(F2+D3)-E3) i have value in column d, e i would showing empty cell in column f if col d,e ="" and if is not it applys this formula =(F2+D3)-E3) so this formula changes in column d,e contain values so it should this = =(F3+D4)-E4) ,=(F4+D5)-E5) and so on