L
Legacy 48831
Guest
I have this formula:
=IF(A2="2400 PSI",IF(F2>"3",F2*D2,F2*C2))
But I need to add basically the same formula 3 more times. I cant figure out how to write the formula:
=IF(A2="2400 PSI",IF(F2>"3",F2*D2,F2*C2)) + =IF(A2="4500 PSI",IF(F2>"3",F2*D2,F2*C2)) + =IF(A2="5000 PSI",IF(F2>"3",F2*D2,F2*C2)) + =IF(A2="6000 PSI",IF(F2>"3",F2*D2,F2*C2))
I know the example I have is not correct but I can't seem to figure it out. Can anyone point me in the right direction?
=IF(A2="2400 PSI",IF(F2>"3",F2*D2,F2*C2))
But I need to add basically the same formula 3 more times. I cant figure out how to write the formula:
=IF(A2="2400 PSI",IF(F2>"3",F2*D2,F2*C2)) + =IF(A2="4500 PSI",IF(F2>"3",F2*D2,F2*C2)) + =IF(A2="5000 PSI",IF(F2>"3",F2*D2,F2*C2)) + =IF(A2="6000 PSI",IF(F2>"3",F2*D2,F2*C2))
I know the example I have is not correct but I can't seem to figure it out. Can anyone point me in the right direction?