IF formula help

[dcdush]

Hey Guys - i need to get the specific cell value if the answer is "NO" can you help ? pls see the snap shot i have attached and as per that. B3 should have C3 value instead of "NO"

https://ibb.co/eHHO79

 

[Fluff]

In that case
=IF(C3>0,C3,"")

 

[dcdush]

sorry i want to keep the cell value as blank if c3 is not greater than 0

 

[Fluff]

If C3 is less than or equal to 0 then B3 will display nothing.
If you mean you want the cell totally empty (ie no formula) then you will need VBA

 

[dcdush]

ok then shall we insert a sign (-). im happy with that. can you help to formulate something ?

 

[Fluff]

Simply replace the "" WITH "-"