View Single Post
 
Old 08-31-2018, 02:22 AM
aysherryan aysherryan is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Aug 2018
Location: Singapore
Posts: 5
aysherryan is on a distinguished road
Default Making blank cells

I have a formula in a cell. The formula includes another cell and a number. For example "=B3*(A1/100)-1". The cell containing the formula shows a number even when B3 and A1 have no values in it. Is there a way to make it show blank until a value is entered into those two cells?
Reply With Quote