hi, I have the below formula, but when its negative, it gets blank and don't print anything on the cell.
please help.Please Login or Register to view this content.
hi, I have the below formula, but when its negative, it gets blank and don't print anything on the cell.
please help.Please Login or Register to view this content.
Currently your formula set to show values that are greater than 0. To see negative values try this
=IF(Quote!E44<>0,Quote!E44,"")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
That is what the formula is doing. It is looking up the sheet "Quote" and if E44 is greater than 0 then it is showing E44 otherwise if E44 is 0 or negative then it is showing a blank cell.
What do you want the formula to do?
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
Thank you allkey, that worked great. I just wanted to show negatives numbers also. Thank you spitfireblue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks