Forum Discussion

Ajcase's avatar
Ajcase
Copper Contributor
Nov 16, 2021

Need calculations help

I am trying to use an IF function with multiple calculations but sometimes one of the cell will contain a 0 and because it can't divide by zero it won't give me the time I need. So I have to go in a e...
Excel for web
Ajcase's avatar
Ajcase
Copper Contributor
Nov 16, 2021
Tried this on my mobile app and it works great but when I put it in my desk top it's giving me the #value! Error
HansVogelaar's avatar
HansVogelaar
MVP
Nov 16, 2021

Ajcase 

The only way I can get the formula to return #VALUE! is if one of the contributing cells B1, D1 and E1 contains #VALUE!

Could you attach a small sample workbook demonstrating the error?

  • Ajcase's avatar
    Ajcase
    Copper Contributor
    Nov 16, 2021

    Ok got the file attached! As you can see in row 3 that is where my problem is happening. F3 is with you suggestion which I thought was going to work but you can see it's giving an error and N3 is with my current formula which works fine as long as one of the 2 cells that is being calculated doesn't contain a zero or blank which will happen sometimes with the system I am using this for

      • Ajcase's avatar
        Ajcase
        Copper Contributor
        Nov 16, 2021

        You will love this when I go back to my example file on my laptop the @ isn,t there but the error is. I'm going to attach a photo

  • Ajcase's avatar
    Ajcase
    Copper Contributor
    Nov 16, 2021
    I dont mind attaching an example at all. This is my first posting how can I attach that now?

Resources