ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel. if g4h4 i want cell j2 to be 0 (https://www.excelbanter.com/excel-programming/363472-excel-if-g4-h4-i-want-cell-j2-0-a.html)

[email protected] uk

excel. if g4h4 i want cell j2 to be 0
 


Trevor Shuttleworth

excel. if g4h4 i want cell j2 to be 0
 
In cell J2, put the formula:

=IF(G4H4,0,"")

Am I missing something ?

Regards

Trevor


uk"
wrote in message
...





All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com