I have an If formula that calculates a rating:
{=IF($C3="2011-01","",IF(F3<-0.115,-1,IF(F3>0.115,1,0)))}
I want to add {IF(F3="",G3="",IF(F3<-0.115,-1,IF(F3>0.115,1,0)))} in between the 1st IF and 2nd IF.
Or in words if the F column is blank I want the rating in the G column to be blank and not turn out 0 like it is doing.
I attached an example to make it easy to see, I feel like the formula I wrote to add in should work but it does not, any help you can give me I would greatly appreciate many thanks!
Bookmarks