This is my formula:
=IFERROR(IF(OR(AND($M$4="volt";U33<>0);U33-$F$26;"");(AND($M$4="auto";U33<>0);U33+$F$26;"");""))
But I can not get it to work.
What I want is that if M4 is "volt" and U33 contains a value, then U33-F26, or if M4 is "auto and U33 contains a value, then U33+F26. If not any of these conditions are fulfilled, then write nothing in the cell (keep it blank).
pls try
Open in new window
Regards