Hi,
I would like to add a formula to a cell that makes the cell blank if the value is 41274. Can anyone help me with this?
Thanks
Niklas
Hi,
I would like to add a formula to a cell that makes the cell blank if the value is 41274. Can anyone help me with this?
Thanks
Niklas
dont know if this will work for you but you could use conditional format and cell value is / equal to 41274
and set font colour to white
=if(formula=41274,"",formula)
Example Solution:
Example situation:
I want it to read C3 and add +4 unless the value of C3 is 41274, if it is 41274 I want it to be blank
=IF(C3=41274,"",C3+4)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks