Forum Discussion

bluejay215's avatar
bluejay215
Copper Contributor
Jul 25, 2022
Solved

Help with an If/And formula

Hi, I've been trying to get a formula to work for a while to no avail and I'm hoping someone here can help. I'd be very grateful for any tips as I feel like I have complete tunnel vision at this poin...
excel
  • HansVogelaar's avatar
    HansVogelaar
    Jul 25, 2022

    bluejay215 

    How about

    =IF(OR(A1="",C1=""),"",IF(A1="Yes",C1,D1)-B1)
HansVogelaar's avatar
HansVogelaar
MVP
Jul 25, 2022

bluejay215 

How about

=IF(OR(A1="",C1=""),"",IF(A1="Yes",C1,D1)-B1)
  • mathetes's avatar
    mathetes
    Gold Contributor
    Jul 25, 2022

    HansVogelaar 

     

    Much more to the point that my convoluted solution. Well done, Hans.

  • bluejay215's avatar
    bluejay215
    Copper Contributor
    Jul 25, 2022
    That seems to be working, thanks so much!

Resources