Forum Discussion
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 Nested IF as follows:
=IF(ISNUMBER(G21),IF(G21<5,"",IF(G21>5,I20-G21)),"")
Hope that helps
Hi,
You can use Nested IF as follows:
=IF(ISNUMBER(G21),IF(G21<5,"",IF(G21>5,I20-G21)),"")
Hope that helps
Worked great, Thanks so much
