clintonmadden
Registered User.
- Local time
- Yesterday, 19:25
- Joined
- Mar 12, 2010
- Messages
- 26
Hi,
I'm trying to find a formula that will only calculate if the data in an adjacent cell is greater that 0 and if not, the cell will remain blank. I'm not sure if I'm going about it in the right way, but I came up with:
=IF(C8<0,(C8*1.175),""), but the cell remains blank no matter what I put in cell C8.
Anyone have any ideas?
Thanks
View attachment Productive.xls
I'm trying to find a formula that will only calculate if the data in an adjacent cell is greater that 0 and if not, the cell will remain blank. I'm not sure if I'm going about it in the right way, but I came up with:
=IF(C8<0,(C8*1.175),""), but the cell remains blank no matter what I put in cell C8.
Anyone have any ideas?
Thanks
View attachment Productive.xls
Last edited: