Hello agian, I have a formula that calculates values...
Now, I want exel to set all returned values that is 0 or below to "" (empty).
formula;
=IF(CG36="slakteklar";(CD37-CD46);IF(CG36="sulting";CF37;((CG36/1000)*CG35)))
Hello agian, I have a formula that calculates values...
Now, I want exel to set all returned values that is 0 or below to "" (empty).
formula;
=IF(CG36="slakteklar";(CD37-CD46);IF(CG36="sulting";CF37;((CG36/1000)*CG35)))
Hi
This should work.
Cheers=IF(IF(CG36="slakteklar",(CD37-CD46),IF(CG36="sulting",CF37,((CG36/1000)*CG35)))=0,"",IF(CG36="slakteklar",(CD37-CD46),IF(CG36="sulting",CF37,((CG36/1000)*CG35))))
James
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks