IF RESULT OF FORMULA IS 0 WRITE EXTIMATOR
A10 cell that is equal that D10 cell, If D10 Cell is blank A Cell will be
writen Estimator. |
One way, try this in A10:
=IF(D10="","Estimator",D10) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "byron" wrote in message ... A10 cell that is equal that D10 cell, If D10 Cell is blank A Cell will be writen Estimator. |
All times are GMT +1. The time now is 10:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com