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]

Why is your formula looking at C4, when you are on row 3?

 

[MUKESHY12390]

probably Fluff is saying correct, are you using wrong Row #?

 

[dcdush]

sorry ! it should be C3.

 

[Fluff]

Does that solve the problem?

 

[dcdush]

NO. i of course dont know how to get the value of the c3 cell instead of IF formula results. can you help ?

 

[Fluff]

You need to explain exactly what you are trying to do.
This is due to the fact that (unfortunately) I am not a mind reader!

 

[dcdush]

sorry !

if c3 value is greater than "ZERO" I need to get the C3 vlaue for the b3 cell. Hope this make sence ?

 

[Fluff]

So if c3>0 put that value in B3. what do you want to do if c3 is not greater than 0?

 

[dcdush]

i want to keep it black if c3 is not greater than 0