79379310

Date: 2025-01-22 21:57:05
Score: 1.5
Natty:
Report link

Don't really get what you mean exactly by check for H6 <> what is <> in your description? The exact values, a hint to a possible string interpolation?

If understood your question correctly, you can basically:

=IF(F6="YES", EDATE(B6,3), 
   IF(F6="NO", EDATE(H6,3), 
     IF(F6="MAYBE", EDATE(B6,6), 
       IF(F6="UNKNOWN", EDATE(H6,6),
       "[Error]: Invalid Condition")
     )
   )
)

enter image description here

Reasons:
  • Probably link only (1):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Low reputation (0.5):
Posted by: Reanimated Man X