Forum Discussion
Solved
Formula
Hi All, I'm trying to develop a formula in Excell that in cell I21, will look at cell G21 and if <5 return a blank cell in cell I21, But if it has a value >5 calculates (I20-G21).
Any help will be great, Thanks
| |
Hi,
You can use https://support.office.com/en-us/article/if-function-%E2%80%93-nested-formulas-and-avoiding-pitfalls-0b22ff44-f149-44ba-aeb5-4ef99da241c8 as follows:
=IF(ISNUMBER(G21),IF(G21<5,"",IF(G21>5,I20-G21)),"")
Hope that helps
2 Replies
Hi,
You can use https://support.office.com/en-us/article/if-function-%E2%80%93-nested-formulas-and-avoiding-pitfalls-0b22ff44-f149-44ba-aeb5-4ef99da241c8 as follows:
=IF(ISNUMBER(G21),IF(G21<5,"",IF(G21>5,I20-G21)),"")
Hope that helps
Worked great, Thanks so much
